Post reply

Is it possible to link to a db on another server without linked server?

  • January 29, 2010 at 9:59 am

    #209554

    I am researching the possibility of using ip address to query data on one server from another instead of using a linked server. Is this possible? If so, what are the performance differences?

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • January 29, 2010 at 12:46 pm

    #1110958

    You could do this at the application layer. Using the same code for each connection, performance v. linked server should be negligible. The use of the BI tools, an application, or clr should be able to get you close to what you need.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 4, 2010 at 11:08 pm

    #1114195

    jared-709193 (1/29/2010)

    I am researching the possibility of using ip address to query data on one server from another instead of using a linked server. Is this possible? If so, what are the performance differences?

    Thanks,

    Jared

    Try OPENDATASOURCE and OPENROWSET.

    Not sure about the performance, but security concerns are there.

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

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