呵呵,调试了一下,证明还是可以用的: 注意要在语句执行前 set XACT_ABORT on 具体如下 1-加连接---------------------------------------------- sp_helpserver '192.30.9.4' if (@@rowcount =0 ) exec sp_addlinkedserver @server = '192.30.9.4', @srvproduct ='SQL Server' go exec sp_addlinkedsrvlogin '192.30.9.4', 'false', 'sa', 'sa', '' go2-TRIGGER------------------------------------------- CREATE TRIGGER [A_insup] ON [dbo].[A] FOR INSERT, UPDATE AS insert into [192.30.9.4].test.dbo.(status) values(1) GO2-查询分析器执行-------------------------------------- set XACT_ABORT on --这一句必须有 go insert into a(status) values(2)
不好意思,刚才写错了,下面的才可以注意要在创建语句执行前 set XACT_ABORT on 具体如下 1-加连接---------------------------------------------- sp_helpserver '192.30.9.4' if (@@rowcount =0 ) exec sp_addlinkedserver @server = '192.30.9.4', @srvproduct ='SQL Server' go exec sp_addlinkedsrvlogin '192.30.9.4', 'false', 'sa', 'sa', '' go2-TRIGGER------------------------------------------- set XACT_ABORT on --这一句必须有 go CREATE TRIGGER [A_insup] ON [dbo].[A] FOR INSERT, UPDATE AS insert into [192.30.9.4].test.dbo.(status) values(1) GO2-查询分析器执行--------------------------------------insert into a(status) values(2)
在查询分析器通过。
我这边的系统中就有触发器中更新远程数据的情况,好象没有问题呀
注意要在语句执行前
set XACT_ABORT on 具体如下
1-加连接----------------------------------------------
sp_helpserver '192.30.9.4'
if (@@rowcount =0 )
exec sp_addlinkedserver @server = '192.30.9.4', @srvproduct ='SQL Server'
go
exec sp_addlinkedsrvlogin '192.30.9.4', 'false', 'sa', 'sa', ''
go2-TRIGGER-------------------------------------------
CREATE TRIGGER [A_insup] ON [dbo].[A]
FOR INSERT, UPDATE
AS
insert into [192.30.9.4].test.dbo.(status) values(1)
GO2-查询分析器执行--------------------------------------
set XACT_ABORT on --这一句必须有
go
insert into a(status) values(2)
set XACT_ABORT on 具体如下
1-加连接----------------------------------------------
sp_helpserver '192.30.9.4'
if (@@rowcount =0 )
exec sp_addlinkedserver @server = '192.30.9.4', @srvproduct ='SQL Server'
go
exec sp_addlinkedsrvlogin '192.30.9.4', 'false', 'sa', 'sa', ''
go2-TRIGGER-------------------------------------------
set XACT_ABORT on --这一句必须有
go
CREATE TRIGGER [A_insup] ON [dbo].[A]
FOR INSERT, UPDATE
AS
insert into [192.30.9.4].test.dbo.(status) values(1)
GO2-查询分析器执行--------------------------------------insert into a(status) values(2)