Changing the name of your SQL Server

Have you ever had to change the name of a server that has SQL Server installed on it?
If you anwered yes, did you know that you also have to change the name in SQL Server?

First run the following :

SELECT @@SERVERNAME

Then run the last part :

sp_dropserver '***PUT SERVERNAME HERE FROM THE FIRST SQL QUERY***'

sp_addserver '**** PUT YOUR NEW SERVERNAME HERE ****', local

All you have to do now is to restart your server, or restart all the SQL services !