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)
>