wildman55
Valued Member
Points: 72
More actions
December 7, 2001 at 10:06 am
#78131
Does anyone know how I can insert data from a table in a database on one MS SQL server into a table in a database on another MS SQL server?
Edited by - wildman55 on 12/07/2001 10:06:58 AM
Andy Warren
SSC Guru
Points: 119902
December 7, 2001 at 11:47 am
#420882
Create a linked server, then you can just use the four part syntax - server.db.owner.table to do the insert. You can use openquery to do the same thing on a more adhoc basis.
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply