How to rename servername in sql server 2000

[7280]

Hi,
I have restored my databases from an old cluster of sql server 2000 to a new one (including system databases).
After that the servername (select @@servername) refers to the old one. Is there a way to modify it in order to match the new one?

Thanks in advance,
Tarek

 

[7280]

I tried with sp_dropserver and sp_addserver but the @@servername becomes null while serverproperty ('servername') reports the new server name correctly.

 

[SQLWilts]

Plagurised from another site - was this you?

restart your server
verify the machine name
check if select @@servername is the same
if not, then use sp_dropserver 'oldname'
restart the services
issue sp_addlinkedserver @server='newname',@local='local'
restart the services

 

[mrdenny]

After you use the sp_dropserver and sp_addserver you need to restart the SQL services.

There's a FAQ around here somewhere (probably in the Admin forum) about renaming a server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com