The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server

 
insert into  #tmp
exec usp_xxxx

报错

    The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "server_name" was unable to begin a distributed transaction.

 

Answer:

将linkserver Enable Promotion of Distributed Transactions   设为false
 

原文：https://www.cnblogs.com/allen0118/p/13229842.html