The first thing that I notice is that you have an the IF UPDATE(STATUS) at the top, but with no BEGIN END statements. This means that only the line directly under the IF command is what happens if the IF is valid. In this case that is the SET NOCOUNT ON.
You would be better off writing the trigger like this so that the trigger can handle more than one record being processed at a time.
<pre>CREATE TRIGGER [Status_Notification] ON [Main]
WITH EXECUTE AS CALLER
AFTER UPDATE AS
SET NOCOUNT ON
declare @xml_value xml
— Select data and build XML
set @xml_value = ‘<MAIN><Number>333</Number><Status>Cancel</Status></MAIN>’
— Insert an entry into the table
insert into q_out
SELECT ‘a’, ‘b’, @xml_value, 1, userial, ‘N’