@@servername

If anybody can explain why for one of my SQL Server2000 servers the statement select @.@.servername returns NULL instead of name?
ThanksThe BOL is incomplete about this subject. Try this microsoft article (http://support.microsoft.com/default.aspx?scid=kb;en-us;303774)

Good luck
Hope this helped|||I'd use:EXECUTE sp_addserver 'desiredServerName', 'LOCAL'-PatP