Please help me with below scenario,
I am not getting any error while update a table that is on diferent server. but when I use Begin Tran I get below mentioned error.
"OLE DB provider "SQLNCLI" for linked server "192.168.10.115" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 2 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "192.168.11.103" was unable to begin a distributed transaction. "
My update statement is as
Things to check:
See [here] for more.: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64
answered May 14 '12 at 07:50 AM