Giving different server names

• Lavanyasri

  SSCarpal Tunnel

  Points: 4907

  More actions

  January 9, 2015 at 4:43 am

  #293628

  Hi All,

  select @@servername and select serverproperty ('servername') giving different outputs ( different server names )

  Thanks,

  Lavanya

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 9, 2015 at 7:33 am

  #1769082

  It's a known issue. Maybe the windows machine was renamed and SQL Server didn't notice it happened.

  serverproperty('servername') returns the correct server name, while @@servername may return the incorrect name.

  Take a look at sys.servers where server_id = 0 and, in case it's wrong, correct it with sp_dropserver/sp_addserver.

  Hope this helps

  Gianluca

  -- Gianluca Sartori