sp_Blitz Result: @@ServerName Not Set

The @@ServerName refers to the local server that SQL Server is running on.  This property is set during installation, but there are instances where @@ServerName may be NULL or may not be correct.  Running the following will show the value for this property:


This part of our SQL Server sp_Blitz script checks @@SERVERNAME to make sure it’s set.

To Fix the Problem

If the @@ServerName property is NULL, running the following and then restarting will fix the issue:

sp_addserver '<LocalServerName>', local

If the @@ServerName property is incorrect, run the following to correct the issue:

sp_dropserver 'old_name'
sp_addserver 'new_name', 'local'

Return to sp_Blitz or Ask Us Questions