How to access server name in sql server 2005

• riteshsc

  Newbie

  Points: 1

  More actions

  April 11, 2008 at 3:11 am

  #184358

  hi,

  i am using stored procedure which put data in another table fron different database.

  so i am using servername.databasename.dbo.tablename.

  if I am change the servername then i have to edit the Stored procedure.

  Is there any way to access server name.so that if server name is chane then also i dont have to change stored procedure.

  Like in c we use #define where we change value of variable that is reflected in whole program.

• Peter Schofield

  Ten Centuries

  Points: 1364

  More actions

  April 11, 2008 at 3:57 am

  #801370

  Obviously the variable @@servername holds the details of the server name, so you can use that perhaps?