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