http://msdn.microsoft.com/en-us/library/aa933172(v=sql.80).aspx
USE master
GO
EXEC sp_dropserver 'OLDSERVERNAME' -- This is the wrong name you got from @@SERVERNAME
GO
EXEC SP_addserver 'NEWNETWORKNAME','LOCAL' -- This is the correct hostname of the box which you can get from windows.
GO