Bryan 2009-07-27 10:07:44
Does anyone know the most optimal way to copy/update data in a table from one
server to another in SQL without using DTS or replication? Are BCP/Bulk
Insert the only options?
Keith kratochv 2009-07-27 10:07:47
You could use a linked server. You could also use OPENROWSET to access one
server from the other.