I had to change the computer name from x to y on a sql server 2008 r2. And followed the instructions [http://msdn.microsoft.com/en-us/library/ms143799.aspx]
Now when I select @@servername it shows null.
However when I Query Select * from sys.servers, the new server name is listed..
@@Servername is used in many of stored procs..