trigger Price_TAB_Audit_trig

create trigger Price_TAB_Audit_trig on dbo.PRICE_TAB after insert, update, delete
as

DECLARE
	@inserted	XML,
	@deleted	XML;

SELECT @inserted =
	( SELECT * FROM inserted FOR XML PATH('row'), ROOT('inserted') );

SELECT @deleted =
	( SELECT * FROM deleted FOR XML PATH('row'), ROOT('deleted') );

EXECUTE SendMsgServiceBroker 'ProcessPriceTabHistory', @inserted, @deleted;