Linked Server

• The_SQL_DBA

  SSChampion

  Points: 10494

  More actions

  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."

• Bijal Parekh

  Mr or Mrs. 500

  Points: 575

  More actions

  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

• nary

  SSCrazy

  Points: 2869

  More actions

  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

• U J

  SSCrazy

  Points: 2423

  More actions

  October 19, 2008 at 2:06 pm

  #886923

  Try this one...Hope it helps 🙂

  select * from openquery(linkedservername,'sp_help')