Inserting Results Of Stored Procedure From Linked Server?
It sounds to me like the support for remote transactions has not been properly enabled Have you tried following the instructions here: The partner transaction manager has disabled its support for remote/network transactions.
It sounds to me like the support for remote transactions has not been properly enabled. Have you tried following the instructions here: The partner transaction manager has disabled its support for remote/network transactions.
1 I was about to post the exact same link – Aaron Bertrand Jul 29 at 14:37.
Where tst is a stored procedure that returns IDs. "OLE DB provider "SQLNCLI" for linked server "linkedserver" returned message "The partner transaction manager has disabled its support for remote/network transactions.". One machine is running SQL Server 2005 and the other 2008, both are running the "Distributed Transaction Coordinator" service.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
Execute sybase stored procedure as linked server procedure sql server 2008?
How to call a stored procedure from another stored procedure in oracle?
Getting value from stored procedure in another stored procedure?
Stored Procedure runs slowly when being called from another stored procedure?
How to get the output value from stored procedure from another stored procedure in a tabular format?
Stored procedure for inserting a constant plus values from another table?