@@servername returns NULL ??

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  November 30, 2004 at 10:17 am

  #91541

  Hi,

  MSSQL 2000/sp3; using Query Analyzer ...

  Any ideas why <SELECT @@servername> returns NULL and what are the steps to ensure that it picks up the server name?

   

  Many thanks. Jeff

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  November 30, 2004 at 12:01 pm

  #531929

  Try SP_Addserver newname, 'local'

   

  You have to stop / star SQL for it to take affect

  
  KlK

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  November 30, 2004 at 12:50 pm

  #531942

  Also, if you are using sql 2000 try

  cast(serverproperty('servername') as varchar(256))

  should return the name even if @@servername returns null

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  November 30, 2004 at 1:08 pm

  #531943

  Hi Wesley, this method does work! Any idea why the @@servername returns NULL and this method doesn't?

  Many thanks. Jeff

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  November 30, 2004 at 3:01 pm

  #531973

  It looks in a diffrent location for the server name @@SERVERNAME was used from 7.0 and back and has to have an entry in the sysservers table to work. that is what the sp_addserver does.

  Wes