• crazy4sql, if you look in BOL at the topic How to: Rename a Stand-Alone Instance of SQL Server 2005, you'll see that

    sp_dropserver <old_name>

    GO

    sp_addserver <new_name>, local

    GO

    is exactly how to do it. As I have many times.