The operation could not be performedbecause OLE DB provider "SQLNCLI" for linked server"****" was unable to begin a distributed transaction.
OLE DB provider "SQLNCLI" for linked server"****" returned message "该伙伴事务管理器已经禁止了它对远程/网络事务的支持
set
xact_abort
ON
BEGIN
DISTRIBUTED
TRANSACTION
insert
into
Mylink.test_bean.dbo.test
select
1
COMMIT
TRANSACTION
;
类似这种需要执行插入更新 LinkedServer的数据,且在事务中会有这种问题.
可参考下面两篇文章
http://blog.sina.com.cn/s/blog_5408b1c80100chhe.html
http://wenku.baidu.com/view/8d57020fbb68a98271fefab4.html