Alter SQL Server Database Name after imaging

If you image a system running SQL Server 2005. The hostname listed in the sys.servers view will contain the old server name. This can be altered to the new server name by executing

sp_dropserver

then add the new server name by executing

sp_addserver , local

If this is not done then features such as replication and logshipping will have issues.