Get local server's alias in T-SQL

• schleep

  SSChampion

  Points: 12586

  More actions

  January 19, 2021 at 5:20 pm

  Go to Answer

  #3835133

  Hello,

  I'm trying to get the server name programmatically.

  Even after I do this:

  exec dbo.sp_dropserver 'FQDN\InstanceName'
  GO
  exec dbo.sp_addserver 'MURPHY', 'local'
  GO

  But @@Servername and SERVERPROPERT('ServerName') both still return FQDN\InstanceName

  In our code, we do stuff like IF <this servername> = "FQDN\InstanceName" ....

  I want to be able to do IF <this servername> = "MURPHY" .... because we're getting brand new equipment and they won't be renaming them to match the old names.

  There's gotta be a a way...surely?

  Thanks!!

   

• schleep

  SSChampion

  Points: 12586

  More actions

  January 19, 2021 at 7:25 pm

  Answer

  #3835170

  ...and then restart the server. D'oh!!

  Skipped right over that line in BOL