Cant see changes to options

• devereauxj

  Hall of Fame

  Points: 3263

  More actions

  July 22, 2005 at 5:44 am

  #88301

  I changed the servername with sp_addservlinkedserver/sp_droplinkedserver. But now when I run select @@servername, I don't see it. I know it changed because If I try runnint sp_add.. again it comes back with a message that it exists. There was some function you run to "update" the view so the values can be seen.

  Any one remember what the was?

  Thanks,

  Joseph

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  July 22, 2005 at 5:59 am

  #576373

  have you tried querying sysservers ?!

  what view are you talking about ?

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• lholman

  SSCrazy

  Points: 2810

  More actions

  July 22, 2005 at 6:29 am

  #576384

  Joseph,

  What do you get returned when you run SELECT SERVERPROPERTY('SERVERNAME')?

  ll