Page History

/*
--TESTING QUERIES:
insert into _as_AuditCrap(dDate, sText) values (GETDATE(), 'bla1');
select * from _as_AuditLog_Print order by ddate desc --7476
select * from SB_AT_ServiceBrokerLogs
*/

create table _as_AuditLog_Print (dDate datetime, query nvarchar(1000))

create trigger _as_TestAsync ON _as_AuditCrap
FOR UPDATE, INSERT
AS
BEGIN
	
	--EXECUTE SB_AT_Fire_Trigger 'dbo._as_InsertPayment 99,232,''blabla'',''2018-06-01''';
	EXECUTE SB_AT_Fire_Trigger '_as_spTestAsync'
END



create procedure _as_spTestAsync
	@Inserted XML,
	@Deleted XML
AS
begin
	--exec _as_InsertPayment 99,233,'adfsad','2018-06-01'
	insert into _as_AuditLog_Print (dDate, query) values (GETDATE(),'async test!');
end