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?