set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date: 
-- Description:	
-- =============================================
ALTER TRIGGER [dbo].[TRGOnDeleteDoc] 
   ON  [dbo].[DocTbl] 
   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 ChangeDocTbl   (SysCode, DocDate, SysDate, UserIDNO, Comment, ArchiveName, Lock  ,OnChangeUserId,OnchangeSysDate,IsUpdated)   select SysCode, DocDate, SysDate, UserIDNO, Comment, ArchiveName, Lock,dbo.funuserid(),getdate(),0  from deleted
END