variables to refer to database server

• prash.dark

  SSC Enthusiast

  Points: 167

  More actions

  May 27, 2009 at 10:22 am

  #200807

  Hi,

  I have created a linked server to access a remote server.i.e. the command

  select * from myserver.mydatabase.dbo.mytable

  will give all rows from mytable from mydatabase located on server myserver. Now the problem is

  - i want to use a variable name for server myserver so that even if my linked server changes from myserver to myserver123 i do not have to modify the query i have written.

  Any help is appreciated. Thanks in advance.

  Reards,

  Prash..

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 27, 2009 at 10:28 am

  #1000806

  Please do not double post. It just fragments any responses you may get regarding your problem.

  Post replies here.