title: avoid "Cannot use SAVE TRANSACTION within a distributed transaction" error between SQL 2005 and 2008
body: <p>in our production environment we have a stored procedure (in sql 2005 server) that import data into a local table from a remote stored procedure (stored in a remote sql 2008).</p>
  
  <p>The code is like this:</p>
  
  <pre><code>insert  &lt;&lt;local table name&gt;&gt; (fund, strat, clr, [id], position, unsettledPosition)
  exec    &lt;&lt;remote stored proc name&gt;&gt; 'aapl us' , '2013-05-13'
  </code></pre>
  
  <p>I receive this error:</p>
  
  <blockquote>
    <p>Cannot use SAVE TRANSACTION within a distributed transaction.</p>
  </blockquote>
  
  <p>and</p>
  
  <blockquote>
    <p>The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.</p>
  </blockquote>
  
  <p>I have configured both local and remote DTC allowing DTC Access over Network, Allowing Remote Clients option, also allowing Inbound &amp; Outbound Communication, and finally enabling XA Transactions, but without any success.</p>
  
  <p>Until yesterday the remote server was an old SQL 2005 and my code worked well, then I guess I miss some config settings in the new server 2008.</p>
  
  <p>Please could someone help me?</p>