ALTER TRIGGER [Trigger1]
ON [dbo].[表1]
FOR UPDATE
ASupdate srv_lnk.表2 set 表2.colname='asdf' where 表1.colname = 'aaa'
go exec sp_dropserver 'srv_lnk','droplogins'
go
ON [dbo].[表1]
FOR UPDATE
ASupdate srv_lnk.表2 set 表2.colname='asdf' where 表1.colname = 'aaa'
go exec sp_dropserver 'srv_lnk','droplogins'
go
ALTER TRIGGER [Trigger1]
ON [dbo].[表1]
FOR UPDATE
ASupdate srv_lnk.表2 set 表2.colname='asdf' where 表1.colname = 'aaa'
go exec sp_dropserver 'srv_lnk','droplogins'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'SA','1111'
go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [Trigger1]
ON [dbo].[表1]
FOR UPDATE
AS
update srv_lnk.表2 set 表2.colname='asdf' where 表1.colname = 'aaa' go --这里再加个GO试一下exec sp_dropserver 'srv_lnk','droplogins'
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.0.1'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'SA','1111'
go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [Trigger1]
ON [dbo].[表1]
FOR UPDATE
AS update srv_lnk.表2 set 表2.colname='asdf' where 表1.colname = 'aaa'
--
go
exec sp_dropserver 'srv_lnk','droplogins'
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.0.1'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'SA','1111'
go