Post reply

Linked Server

  • October 16, 2008 at 9:53 am

    #71368

    Is there a way in SQL Server 2000(SP4) stored procedures to “link” or join tables from one server to the next in a “Select” query? If so can it be done with One DB on SERVER A to Many Databases on Server B (all have related tables)

    Thanks!!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • October 17, 2008 at 2:28 pm

    #886667

    Not Sure what you mean..but I hope this helps

    Once you have added other Servers to Server A as linked server. you can use the four part name to reference any objects on the linked server like [ServerName].[databasename].dbo.[objectname].

    I hope this helps

  • October 17, 2008 at 2:40 pm

    #886677

    I guess if your SP needs to pull/push data to other databases for diffrent servers then Linked Server , Open query aresimple solutions but if you means using SP in SELECT Statement it would be better if you illiustrate with example to better answer your Question.

    Thanks

    Narinder

  • October 19, 2008 at 2:06 pm

    #886923

    Try this one...Hope it helps 🙂

    select * from openquery(linkedservername,'sp_help')

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

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