title: Executing s. procedure from linked server, filling table
body: <p>OLE DB provider "SQLNCLI11" for linked server "server1" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
  Msg 7391, Level 16, State 2, Procedure sp2, Line 12
  The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "server1" was unable to begin a distributed transaction.</p>
  
  <p>and procedure is simple </p>
  
  <pre><code>insert into #tmp2 exec sp2 @d1, @d2, 0
  </code></pre>
  
  <p>without insert, it's working, like <code>exec sp2 @d1, @d2, 0</code></p>
  
  <p>I don't have transaction anywhere.</p>
  
  <p>What can be problem?</p>