Post reply

Query 2 servers

  • February 28, 2005 at 5:00 am

    #85259

    As i can make one query SQL that joins table information of 2 servers SQL??

    Tks

  • February 28, 2005 at 5:43 am

    #544389

    Yes, this is possible.  To query two servers you will need to create a linked server.  You would need to fully qualify the table on the second server.  For example...

    SELECT ColA, ColB

    FROM Server2.Database1.dbo.Table1

    You can find plenty of information on Linked Servers in these forums or in BOL.

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

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