Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Linked server problem

Author  Topic 

jayanth_jyothi
Starting Member

11 Posts

Posted - 2010-09-25 : 17:34:54
Hi,

I created synonym for one table in remote server and then i created one procedure to insert data into the same

when i executed the procedure i am getting the below error

Thanks for your help in advance

OLE DB provider "SQLNCLI10" for linked server "SVTSSQL012" returned message "The transaction manager has disabled its support for remote/network transactions.".

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-09-26 : 02:22:21
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/c67833cc-9b8f-4255-8edf-40e9401ed078

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -