Hello All,
I have created a Linked Server on Server A between A and B and the test connection works successfully but when i tried to access a stored procedure on Server B, i.e. tried to insert a record it throws me a error
OLE DB provider "SQLNCLI11" for linked server "Server B" returned message "The partner transaction manager has disabled its support for remote/network transactions.".Msg 7391, Level 16, State 2, Line 7
The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "Server B" was unable to begin a distributed transaction.
Here is the query
Declare @xxx
Set xxxx
Create table tbl,
(
)
Insert into table execB.db.storedprocedure xxx
select * from tbl