MSSQL - Changing Computer Name

SELECT @@SERVERNAME        -- check current servername;

-- restart sql service after name change

EXEC sp_dropserver 'OldComputerName';         -- remove old server name

EXEC sp_addserver 'NewComputerName', local;  -- add new server name