To rename a computer that hosts a stand-alone instance of SQL Server

Once you have renamed your server from ServerA to ServerB you will notice that if you run the following:

SELECT @@SERVERNAME

You will still see that SQL thinks it is still called ServerA.

To resolve this you will need to run the following:

sp_dropserver ServerA
GO
sp_addserver ServerB, local
GO