SQL Server - What is the fastest way to copy table data to another server? -

I have two MS SQL servers that are in various places on the w. I currently have to copy table data from one to the other I use linted servers, but there is a display toilet, it takes around 10 minutes to copy a 40 field table with 800 rows.

The best 'simple' way to copy / replace the table data on a different SQL Server is to have this solution be scripted because it needs to be done every hour. The master server is SQL 2000, the linked server is SQL 2005.

I appreciate any help.

Andrew

for example export a server (master) to a file And use the bulkwrite command line to import files. Both solutions can be easily used through command line and also by scripting!