Export (0) Print
Expand All

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

SQL Server 2000

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft