title: Reference column in a table on another server in an UPDATE/JOIN (SQL Server)
body: <p>I'm familiar with 4-part naming, but I get an error every time I try to reference a column.  For example:</p>
  
  <pre><code>UPDATE my_table
  SET my_table.column1 = otherserver.otherdatabase.dbo.othertable.column1
  FROM my_table INNER JOIN otherserver.otherdatabase.dbo.othertable
  ON my_table.column2 = otherserver.otherdatabase.dbo.othertable.column2
  </code></pre>
  
  <p>This throws the following error:</p>
  
  <blockquote>
    <p>The multi-part identifier "otherserver.otherdatabase.dbo.othertable.column1" could not be bound.</p>
  </blockquote>
  
  <p>I never have trouble if I am only reference a table, but when I append the column name, it always throws an error.  Any ideas?  SQL Server 2008</p>