title: Azure Linked Server RPC error with Stored Procedures
body: <p>I have an Azure database setup as a Linked Server which can be queried fine. I can also execute stored procedures without any issue.</p>
  
  <p>However as soon as I try inserting the results of a stored procedure call into a table I get an RPC failure: -</p>
  
  <pre><code>[Microsoft][SQL Server Native Client 11.0]
  The partner transaction manager has disabled its support for remote/network 
  transactions.
  </code></pre>
  
  <p>I have set RPC Out to true on the Linked Server properties and have MSDTC running as a service.</p>
  
  <p>To replicate: -</p>
  
  <pre><code>exec [AzureLinkedServerName].myAzureDB.dbo.usp_MyStoredProc 
  </code></pre>
  
  <p>Runs without error and returns a list of email addresses.</p>
  
  <pre><code>DECLARE @res TABLE (id INT IDENTITY (1,1), email nvarchar(255))
  
  INSERT INTO @res
          ( email )
  exec [AzureLinkedServerName].myAzureDB.dbo.usp_MyStoredProc 
  </code></pre>
  
  <p>Fails with the RPC error.</p>
  
  <p>Any ideas?</p>