Post reply

query analyzer and linked server

  • December 13, 2006 at 10:05 am

    #115396

    Is it possible to query the table of a remote data server (MS SQL) in "query analyzer" without using a Linked Server? What are the items that I need to setup\know in order to do that?

     

    For example:

     

     

    Select

    local.*,

    Rmt.*

    From

              LocalServer.LocalDatabase.dbo.Table1 local,

              RemoteServer.RemoteDatabase.dbo.Table2 Rmt

     

     

     

    NOTE: Query analyzer current server is “Local”

     

     

     

  • December 13, 2006 at 10:11 am

    #677849

    You can use the OpenRowset() function to return a recordset from another server without having to setup a linked server.

    See OpenRowset() topic in BOL.

  • December 13, 2006 at 7:03 pm

    #677971

    I spent 4 hours searching Google for this answer, you’re the man.

    Thanks PW, to your time and effort to answer my question.

  • December 13, 2006 at 7:22 pm

    #677974

    Next time start from BOL.

    _____________
    Code for TallyGenerator

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

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