Rename a server

Hi I am running MSSQL2000 and recently installed the server software and
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one shoul
d
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.