title: Insert into local table from remote exec stored procedure
body: <p>I've tried this:</p>
  
  <pre><code>insert into MyTable (col1, col2... coln)
  exec remoteServer.remoteDB.dbo.StoredProcedure.
  
  The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
  </code></pre>
  
  <p>Local server is SQL 2000, remote is 2008.</p>
  
  <p>Any idea?
  When I try executing the stored procedure things run smoothly, I get the result <code>SELECT</code> So the problem is at copying.</p>
  
  <p>I've tried enabling MSDTC and it's configuration (as seen <a href="http://support.microsoft.com/kb/816701" rel="nofollow">here</a>)</p>