I have 2 linked servers and need to call a stored procedure on 1 linked server within a stored procedure of another server. Everytime I attempt this i get the following error:
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTran
saction returned 0x8004d00a].
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
I know the 2 servers are linked because i can execute the remote stored procedure in a sql editor but not within another stored procedure. I also followed all steps outlined in: http://support.microsoft.com/kb/816701
but continue to get this exception. Any help would be greatly appreciated.