Post reply

Getting data from a different database/different server

  • July 20, 2010 at 6:30 am

    #144188

    I am sure I can do this, but I have an instance where I do not want to "recreate" a table, but reference data from a table on a totally different SQL server instance (and version, which is 2000) and different hardware box. I am sure this is possible. Is this where I need to do a linked server? And then I can join that table to my query?

    Thanks for the information.

  • July 20, 2010 at 7:30 am

    #1195504

    Yes, a linked server would be needed, but be careful joining it in queries. Depending on the size of the tables, it could be a significant performance hit.

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 20, 2010 at 1:32 pm

    #1195772

    We have used linked server. We also create separate logins, provide necessary access and execute linked server using the above login.

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

  • July 20, 2010 at 4:03 pm

    #1195848

    Thanks for the responses

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

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