I installed SQL Server 2005 on a machine named "hardName" and then tested the install. We then made a DNS alias so the machine could be referenced as "easyName." I have corrected @@servername via
a) select @@servername
b) sp_dropserver oldName
c) sp_addserver newName,local
d) Bounce the server.
e) select @@servername
The question is, how can I correct serverproperty('servername') without changing the machine's physical name? The system administrators want to reference the computer via "hardName" but the users prefer "easyName."
One of the reasons for this process was because an old machine "easyName" was up during the install and during the migration of databases from "easyName" to "hardName." Now that the migration is complete, I want to finish renaming the database instance.