title: SQL Studio Management - How to run queries across multiple servers
body: <p>My 2 server both use SQL Server 2008 R2</p>
  
  <p>I have my local SQL server and also an Amazon machine running an instance of SQL-Server there.  </p>
  
  <p>I'm able to connect from my local machine to that Amazon SQL using the standard <code>10.10.10.10, 1433</code> connection from my local Management Studio.</p>
  
  <p>What i need to do now is to run a query that says ..tells me what records I have locally that are not on the Amazon server right now.</p>
  
  <p>Something like:</p>
  
  <pre><code> SELECT * 
   FROM [LOCAL].dbo.Table1  
   WHERE Field1 NOT IN   
         (SELECT Field1 FROM [AMAZON].Database1.dbo.Table1)
  </code></pre>
  
  <p>================================
  Question:<br>
  I don't know how to write the "AMAZON" location on the Query window itself, since it's running on a different server.</p>
  
  <p>Any help is truly appreciated !!!</p>