<div>
here's a start:<br />
<a href="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" rel="ugc">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</a>
</div>


here's a start:
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 [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]

<div>
Try :<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET XACT_ABORT ON <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Before BEGIN TRAN 
</div>


Try :

      SET XACT_ABORT ON

      Before BEGIN TRAN

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


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

<div>
<div class="content wysiwyg-content">
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.<br />
&nbsp;<br />
OLE DB provider &quot;SQLNCLI&quot; for linked server &quot;m24prd&quot; returned message &quot;The transaction manager has disabled its support for remote/network transactions.&quot;.<br />
Msg 7391, Level 16, State 2, Line 1<br />
The operation could not be performed because OLE DB provider &quot;SQLNCLI&quot; for linked server &quot;m24prd&quot; was unable to begin a distributed transaction.<br />
&nbsp;<br />
Suggestions?
</div>
</div>


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?

SQL 2005 Linked Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.