View Single Post
 
Old January 31st, 2005, 11:11 AM
shahchi1 shahchi1 is offline
Friend of Wrox
 
Join Date: Jan 2004
Location: , , USA.
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Agree with Jaime,DTS (Start-->Run-->DTSWIZ) is the best way,
OR
In case of linked server (look for it in Books Online)

INSERT INTO database.owner.destination
SELECT *
FROM Source