问下sql server2005中触发器生成不了的问题
我在两台同为windows2003的机器上生成同样表的触发器一台正确一台不行?问下是怎么回事,触发器代码如下:
USE [testdb]
GO
/****** Object: Trigger [dbo].[DELETE_N_test007] Script Date: 03/18/2009 16:34:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[DELETE_N_test007]
ON [dbo].[test007]
FOR DELETE
AS
declare
@loginame varchar(20)
select @loginame=UPPER(loginame) from master.dbo.sysprocesses where spid=@@SPID
if @loginame='SYSDATA'
return
insert into t_db_change
select 'dbo.test007','char1',char1,null,null,null,null,null,null,null,null,getdate(),2,1,'n_test007' from deleted