Renaming SQL Server

[Andel]

Hi, is there a way to change the name of a server? I'm using SQL 7 and SQL 2000.
Andel
maingel@hotmail.com

 

[Husein]

I don't think you can rename the server. What you can do is to register another server and then using DTS package, transfer your tables, SP's and so on into the new one.

 

[Bernadette]

You can check your SQL server name by

1. Open Query Analyser
2. type "select @@servername"

You can rename your server by using

1. sp_dropserver to drop the current server
2. sp_addserver to add your server under the new name

Check these out in "Books OnLine"

Good Luck
Bernadette

 

[Guest_imported]

With sql 6.5, renaming a server was as easy as just renaming a computer. Now, with v7 and 2000, when you rename the server, you have to reinstall sql. But the good news is, it only takes 2 minutes for it to reinstall to completion.

When you use sp_dopserver and sp_addserver, you are not actually renaming the server, but giving it an alias.