There maybe circumstances, where you want to use a backed up / cloned OS image including SQL Server and rename the system. Just think of restoring an old XPe development environment for some image changes in a project.
Very often SQL Server is having a problem, because it stores the original name of the machine in its system database.
Several of my RD colleagues, Kimberly, Venkatagaran and Scott have found a way to solve this very elegantly via stored procedures.
Thanks a lot guys!