I need to rename a SQL 2000 Server. Looking at books online and other resources, I found some information on the process but wanted the groups input on any gotchas.
From what I have read I need to do the following:
sp_dropserver <old name>
go
sp_addserver <new name>, 'local'
Change all procs and jobs that refer to old server. Relink linked servers. Reregister new name in enterprise manager. Stop and restart server.
Should I be concerned about adding the new server name to the add network library configuration, manually updating sysservers or updating sysjobs in msdb. Any additions welcomed? Thanks.