title: SQL How to copy a table to another server
body: <p>I'm using VPN connection and remote desktop to login a server and trying to get data from one table. </p>
  
  <p>I tried "Generate Scripts" but it's too large and when I run it at local SQL server (2008), it shows "out of memory". Then I tried to connect to their DB on local SQL Server Management Studio, but then failed because of permission issue. Also, it's kind of impossible to backup the whole database because of its size. </p>
  
  <p>Is there any other method to help me copy from one table to another server? Also, is it possible to back up only at table level? </p>