View Single Post
  #2 (permalink)  
Old March 2nd, 2007, 02:00 PM
robprell robprell is offline
Friend of Wrox
 
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

try looking into remote procedure calls.

Call up a stored proc or do a select from server X but on server Y (requires that they have been linked) then output the stored procedure or select to the local server X.

select into test * from (Server Name).(Database Name).(Owner).(Table Name)

run this on the server you want to move the data to, not from.