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' go sp_addserver 'new_name', 'local' go