OLE DB provider "SQLNCLI11" for linked server "" was unable to begin a distributed transaction

6.3k Views Asked by At

I use sp via link server. I want insert out put of this sp into table . when I run my sp it throw bellow error:

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

Declare @Table Table (id int , ...)
INSERT INTO  @Table
EXEC [LinkServeName].BimeDW.dbo.sp_ExecuteSql

I search for this error and understand that I should check "allow inbound" and "allow outbound" for msdtc service but My server work 24 hours a day and I really fear What Happen If I check these two check mark. I would glad if somebody who can describe for me?

0

There are 0 best solutions below