Changing Sql Server name

To change the server name first drop the old one:

EXEC SP_DropServer 'OLDNAME'


And now add new server

EXEC SP_AddServer 'NEWNAME','local'


Restart Sql Service for the changes to take place.

Memeber of setupadmin and sysadmin fixed server roles can only execute sp_addserver