title: Insert into table.. exec at linked server does not work
body: <p>This works, returning a resultset :</p>
  
  <pre><code>exec ('select ''col'', count(1) from test.dbo.[Table1] with (nolock)') at svrA
  </code></pre>
  
  <p>When I try to insert the resultset into a table:</p>
  
  <pre><code>insert into rowcount_sub (tablename,rowcnt)
  exec ('select ''col'', count(1) from test.dbo.[Table1] with (nolock)') at svrA
  </code></pre>
  
  <p>Fails giving this error:</p>
  
  <pre><code>OLE DB provider "SQLNCLI10" for linked server "svrA" returned message "No transaction is active.".
  Msg 7391, Level 16, State 2, Line 1
  The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "svrA" was unable to begin a distributed transaction.
  </code></pre>