April 9, 2013 at 12:57 pm
I created a linked server in "ORDERALL" to remote server "ORDER".
Exec one store procedure from "ORDERALL" to insert record to a table in "ORDER" got an error below.
How to fix it?
OLE DB provider "SQLNCLI10" for linked server "ORDER" returned message "The transaction manager has disabled its support for remote/network transactions.".
April 9, 2013 at 1:18 pm
Try this as a starting point. The problem is you don't have distributed transactions enabled.
http://stackoverflow.com/questions/1258983/problems-with-msdtc-remote-transactions
A google/bing search of your exact error message returns hundreds and hundreds of explanations of how to solve this.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply