sql server 2008 - delete trigger not working -


i have delete trigger on table in db supposed inserting rows "audit" table, when delete rows trigger table, not show in audit table. have insert , update triggers following same format work fine can't seem 1 work. here trigger:

use [outagedev] go set ansi_nulls on go set quoted_identifier on go alter trigger [dbo].[tr_audoutagesummarydelete] on [dbo].[outage summary] after delete   begin       -- set nocount on added prevent result sets       -- interfering select statements.       set nocount on;        insert dbo.[outage summary audit]                   (outagesummaryid,                    dispatcher,                    /*removed columns brevity*/                    stateemergency,                    comment,                    auditdatetime,                    audituser,                    auditaction)       select d.outagesummaryid,              d.dispatcher,              /*removed columns brevity*/              d.stateemergency,              t.comment,              getdate(),              suser_sname(),              'delete'         deleted d              join [outage summary] t                on d.outagesummaryid = t.outagesummaryid   end  

for future reference, joining deleted table trigger table in order select columns of type ntext because how worked insert , update triggers. since after delete trigger, row trying select deleted. converted columns ntext nvarchar(max) , got rid of join , works fine now.


Comments

Popular posts from this blog

How to mention the localhost in android -

php - Calling a template part from a post -