title: SQL query :Copy one table to another from different servers
body: <p>What's wrong with my query, I want to copy three columns to another server\table if one of the column (ID_DIRCT) is not null :</p>
  
  <pre><code>INSERT INTO  System\Syst3.Server1.dbo.TABLE_RESRC (NO_EMPLY,PR,NM_FAML,CO_DIRCT)
  SELECT NO_EMPLY, PR_EMPLY, NM_EMPLY, ID_DIRCT 
  FROM System\Syst3.Server2.dbo.RESRC
  WHERE System\Syst3.Server2.dbo.RESRC.ID_DIRCT IS NOT NULL
  </code></pre>
  
  <p>Using SQL Server 2008 R2.</p>
  
  <p>Thanks.</p>