Post reply

Referencing Table on a Linked Server

  • August 31, 2007 at 6:31 am

    #118339

    We have one copy of SQL Server 2005 standard edition with three instances (dev, test, and prod).

    I want to read a table in the dev instance while connected to the test instance.

    How would I do this?   This is, what is the sql syntax?  Is it only possible by setting up a linked server?

  • August 31, 2007 at 6:53 am

    #730745

    Patrick,

    you could use the OPENROWSET function, but if you need to do these type of queries regurlarly I would prefer a linked server.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • August 31, 2007 at 7:43 am

    #730767

    Thanks, Markus.

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

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