title: SQL Update across Linked Server
body: <p>I have a Linked Server set up on my host Server: "MyLinkedServer"
  I have an SP on my server "HostServer".</p>
  
  <p>I am calling a stored proc on HostServer that updates a table in DatabaseA on MyLinkedServer with values from a table in DatabaseB on MyLinkedServer.</p>
  
  <p>I have other SPs that run fine in the same scenario, but they are doing inserts and deletes, however this SP fails to update the table in DatabaseA (no error returned, just no changed data), and if I change connections to actually run the SP on "MyLinkedServer" it works without a problem.</p>
  
  <pre><code>UPDATE MyLinkedServer.DataBaseA.dbo.MyTable
  SET Column1 = db2.Column1
  
  FROM MyLinkedServer.DataBaseA.dbo.MyTable db1
  INNER JOIN 
          (
              SELECT TOP 1 Column1 
              FROM MyLinkedServer.DataBaseB.dbo.MyTable db2
              WHERE db2.Id = 2
          ) AS db2 ON db2.Id = 2
  
  WHERE db1.Id = 1
  </code></pre>