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
Post a Comment