Changing the name of a SQL Server

After changing the computer name on a MS SQL Server you will need to run the following SQL query:

 

sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO