Post reply

Data access between two SQL Server instances

  • March 15, 2004 at 3:04 am

    #107788

    Hi

    How to access data stored in two SQL Server instances running on two different machines.

    Any help in this regard would be highly appreciated.

    Regards

    Chandu

     

     

  • March 15, 2004 at 4:41 am

    #498721

    use sp_addlinkedserver Stored Procedure to connect to the database you want to accessdata from and you should be able to access data between any number of instances like

    select * from <Server Name>.<DB Name>.<Owner like dbo>.<Table Name>

    with appropriate conditions and relationships whatsoever.

    Prasad Bhogadi
    www.inforaise.com

  • March 17, 2004 at 8:18 am

    #499122

    you could also created a linked server through EM or use the sp_addlinkedserver SP and then use the OPENQUERY - something like

    SELECT *

    FROM OPENQUERY(SERVERNAME, 'SELECT *  FROM TABLE_NAME')

  • March 18, 2004 at 2:26 am

    #499270

    Thanks for the response.

    How to create linked server through EM?

    Regards

    Chandu

     

     

  • March 23, 2004 at 8:39 am

    #500042

    Open EM --> DB -->security-->right click linked server-->new linked server.  Its pretty basic from there

  • March 23, 2004 at 8:51 am

    #500046

    Thanks Vikram.

Viewing 6 posts - 1 through 5 (of 5 total)

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