The operation could not be performedbecause OLE DB provider "SQLNCLI" for linked serve

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