6,129
社区成员
发帖
与我相关
我的任务
分享
--通过连接服务器查询信息
select *from Mylink.test_bean.dbo.test
go
alter trigger t
on test
after insert
as
begin
set xact_abort ON
BEGIN DISTRIBUTED TRANSACTION
insert into Mylink.test_bean.dbo.test
select 1
COMMIT TRANSACTION;
end
go
--insert test
insert into test
select 1
/*
Msg 7391, Level 16, State 2, Procedure t, Line 8
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Mylink" was unable to begin a distributed transaction.
*/