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_addserver <new_name>, local
is exactly how to do it. As I have many times.
"Hang on lads, I've got a great idea. "
Michael Caine (Charlie Croker) The Italian Job