Here’s a little simple one that I’ll probably need again, so I thought I’d just blog it:
How to rename a SQL server used mostly when the windows server it resides on changes names:
To change the name of a default instance of SQL, run the following procedures:
sp_dropserver <old_name>
GO
sp_addserver <new_name>, local
GO
To change the name of a named instance of SQL, run the following procedures:
sp_dropserver <old_name\instancename>
GO
sp_addserver <new_name\instancename>, local
GO
