Post reply

How to access onserver database tables in another server

  • April 21, 2009 at 10:18 pm

    #384411

    Hi,

    I have table emp in dbserver1 and i need to utilise these table data in dbserver2 in sql server 2005

    Thanks
    Dastagiri.D

  • April 21, 2009 at 11:59 pm

    #981955

    Add the dbserver1 as linked server on the dbserver2.

    Then you can query the dbserver1 table from dbserver2 as:

    select * from dbserver1.databasename.schemaname.emp

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

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