Here is what I ran:

This will

exec sp_dropserver 'hqsq_GOLD\NP' --the incorrect name

go

exec sp_addserver 'HQSQLTST01\NP','local' -- the correct name

go

Yes, I did include the named instance. (NEWSERVERNAME\Instance)

Rudy,

I have a VM SQL Server. When I copied the VM and created a new server, the SQL server in SELECT @@SERVERNAME is the original server.

I followed the suggestions:

exec sp_dropserver...