title: Copy table to a different database on a different SQL Server
body: <p>I would like to copy a table from one database to another. I know you can easily do the following if the databases are on the same SQL Server.</p>
  
  <pre><code>SELECT * INTO NewTable FROM existingdb.dbo.existingtable;
  </code></pre>
  
  <p>Is there any easy way to do this if the databases are on two different SQL Servers, without having to loop through every record in the original table and insert it into the new table?</p>
  
  <p>Also, this needs to be done in code, outside of SQL Server Management Studio.</p>