title: Syntax for referencing a Linked SQL Server
body: <p>EDIT: Disregard this post. Apparently SQL Azure doesn't allow referencing other Databases :\</p>
  
  <p>I have two databases A and B, which are on different servers, and B is on a SQL server S.
  B is linked to A.</p>
  
  <p>I am trying to access entries from the id column of Table R in database B and put them in A.</p>
  
  <p>This is incorrect according to Microsoft SQL Server Management Studio, because I am getting a multi-part identifier could not be bound error:</p>
  
  <pre><code>S.B.dbo.R.id
  </code></pre>
  
  <p>Any suggestions?</p>