关闭触发器:

ALTER TABLE fab060t disable TRIGGER udt_fab060t_u

ALTER TABLE fab060t enable TRIGGER udt_fab060t_u

 

 

改SQL2000服务器名:


sp_helpserver

exec sp_dropserver 'old', 'droplogins'
go

exec sp_addserver 'new','local'

然后重启SQL Server服务