jdr0606
asked on
SQL 2005 Linked Server
I can query a table via linked server however if I try to update a table via a linked server pathing I get the following error.
OLE DB provider "SQLNCLI" for linked server "m24prd" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "m24prd" was unable to begin a distributed transaction.
Suggestions?
OLE DB provider "SQLNCLI" for linked server "m24prd" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "m24prd" was unable to begin a distributed transaction.
Suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try :
SET XACT_ABORT ON
Before BEGIN TRAN
SET XACT_ABORT ON
Before BEGIN TRAN
ASKER
Currently working with a local engineer to correct and will update when the issue is resolved.
http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-how-do-i-configure-sql-server-to-enable-distributed-transactions-via-linked-server.aspx