Changing Host Name of Server w/ SQL Installed

If you need to change the host name of a Windows Server with SQL Server already installed on it, there are two Stored Procedures that need to be run on SQL Server to change the server name within SQL.

After renaming the host and rebooting run the following two procedures with the appropriate host names and the restart SQL.

sp_dropserver OldServerName
go
sp_addserver NewServerName, local
go