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