Post reply

insert data into table on separate server

  • 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

  • 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

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply