Renaming a server with SQL 2000 installed

Does anyone know if there would be any issue with SQL if I rename my server?
What complications could this cause?
If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:

> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?
|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)
|||Thanks for you help!
"Paul Ibison" wrote:

> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>