title: The multi-part identifier could not be bound error, despite both the servers have already been linked
body: <p>Trying to update data from one server to the server. There are 3 columns: Year, Site and Code that need to be updated from my current server to Server2, however I keep on getting the error of "The multi-part identifier could not be bound." Below is my query:</p>
  
  <pre><code>UPDATE [Server2].[Fleet].[dbo].[log]
  SET
  [Server2].[Fleet].[dbo].[log].[Year] = Poll.[Year],
  [Server2].[Fleet].[dbo].[log].[Site] = Poll.[Site],
  [Server2].[Fleet].[dbo].[log].[Code] = Poll.[Code]
  FROM (SELECT Year, Site, Code
      FROM sacfindb.[UC_POLog].[dbo].[ctbl.Main.Report]
      WHERE Year = left(convert(varchar,getdate(),126),7)
          AND Site = '7115'
          AND Code IN (
              '52120','52140','52147','52146','52182'
          )
      ) Poll
  </code></pre>