@@servername returns null

• robgriff85

  SSC Rookie

  Points: 40

  More actions

  August 5, 2003 at 3:23 pm

  #358099

  I'm running SQL2000 and when I check for 'select @@servername' it returns null. I've tried using sp_addserver 'servername, 'local' and restarting SQL Server but had no luck. When I query the sysservers table there is one record and it has the correct srvname. The only thing I can see amiss in the table is that the srvid is 1 rather than 0.

  Any suggestions or am I looking at a re-install of SQL Server?

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 5, 2003 at 3:37 pm

  #468737

  BOL says to shut the server down and restart after doing the sp_addserver. Maybe this means the box rather than the SQL service? Worth a try.

  Cheers,

  - Mark

  
  Cheers,
  - Mark

• cneuhold

  Hall of Fame

  Points: 3375

  More actions

  August 6, 2003 at 4:12 am

  #468769

  try

  select serverproperty('ServerName')

  best regards,

  chris.