title: SQL Server - What is the fastest way to copy table data to another server?
body: <p>I have two MS SQL servers at different locations on the WAN. At the moment I use LINKED servers to copy table data from one to the other, but performance is toilet. It takes about 10 minutes to copy a 40 field table with 800 rows.</p>
  
  <p>What is the best 'simple' method of copying/replacing table data on a different SQL server. This solution must be scriptable as it needs to happen every hour. The master server is SQL 2000, the linked server is SQL 2005.</p>
  
  <p>I appreciated any help given.</p>
  
  <p>Andrew</p>