How to change to the current server name in the SQL Server 6.5 master database (ISQL/w)

How to change to the current server name in the SQL Server 6.5 master database (ISQL/w)

To change to the current server name in the SQL Server 6.5 master database

1. Start Microsoft® SQL Server™ in minimal configuration mode. In a command prompt window, from the \Mssql\Binn directory, run:

   sqlservr -f
   

2. On the Start menu, point to Programs /Microsoft SQL Server 6.5, and then click ISQL/w.
   
   
3. Enter the sa password, and then click Connect.
   
   
4. Execute SELECT @@SERVERNAME to retrieve the former server name.
   
   
5. Execute sp_dropserver to drop the former server.
   
   
6. Execute sp_addserver to add the current server.
   
   
7. Stop SQL Server. In the command prompt window, press Ctrl+C.
   
   
8. Restart SQL Server.
   
   
9. Execute SELECT @@SERVERNAME to verify the current server name.

Examples

--Start SQL Server in minimal configuration mode.
--Retrieve the former server name.
SELECT @@SERVERNAME
--Drop the server returned from the previous select.
sp_dropserver 'SERVER6X'
--Add the current server.
sp_addserver 'SERVER70', local
--Stop SQL Server.
--Restart SQL Server in minimal configuration mode.
--Verify the current server name.
SELECT @@SERVERNAME