SQL 2005 Linked Server

jdr0606 used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
I have found 1 workaround: copy (insert) the data into a local staging table ...

apart from that, you would need to ensure that the DTC service is running and properly configured on the remote server AND the local server.
musalmanERP Consultant

Try :


      Before BEGIN TRAN


Currently working with a local engineer to correct and will update when the issue is resolved.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial