how to change the name of a sql server?
To correct this, we need to first run sp_dropserver 'Old server Name' in the master database. Next, we run sp_addserver 'New server name','local' in the master database. After running this, restart the SQL Server services. Now check the new name of the instance by running select @@servername.