set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[TRGOnDeleteDocDetail] ON [dbo].[DocDetailTbl] after DELETE AS BEGIN SET NOCOUNT ON; if exists(select * from deleted where not ArchiveName is null and ArchiveName<>'') raiserror (50209,16,1) else insert into ChangeDocDetailTbl (Syscode, Fk_docSysCode, Fk_AccountSyscode, AmmountIN, AmmountOUT, UserRowNo, ArchiveName, SndFk_AccountSyscode, Comment,OnChangeUserId,OnchangeSysDate,IsUpdated) select Syscode, Fk_docSysCode, Fk_AccountSyscode, AmmountIN, AmmountOUT, UserRowNo, ArchiveName, SndFk_AccountSyscode, comment,dbo.funuserid(),getdate(),0 from deleted END