Best way to rename a server

Running SQL 7.0 and need to change the server name. What is the best way to
accomplish this?"Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
news:uOE8IFVhEHA.1156@.TK2MSFTNGP10.phx.gbl...
> Running SQL 7.0 and need to change the server name. What is the best way
to
> accomplish this?
>
As I recall, it's exactly the same as SQL Server 2000, from BOL, "renaming a
server"
~~~~~~~~~~~~~~~~~~~~~~~~~~
You can connect to SQL Server using the new computer name after you have
restarted the server. However, to correct the sysservers system table, you
should manually run these procedures:
sp_dropserver old_name
GO
sp_addserver new_name, local
GO
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Be aware that if are using replication there
will be additional steps involved.Steve|||Steve,
Thank you for these instructions - we are not using replicaton and we have
manual backups of all the databases - I will use your instructions.
TR
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:e9sYzQVhEHA.1356@.TK2MSFTNGP09.phx.gbl...
> "Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
> news:uOE8IFVhEHA.1156@.TK2MSFTNGP10.phx.gbl...
way[vbcol=seagreen]
> to
> As I recall, it's exactly the same as SQL Server 2000, from BOL, "renaming
a
> server"
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
> You can connect to SQL Server using the new computer name after you have
> restarted the server. However, to correct the sysservers system table, you
> should manually run these procedures:
> sp_dropserver old_name
> GO
> sp_addserver new_name, local
> GO
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Be aware that if are using replication there
> will be additional steps involved.Steve
>|||You might want to check my article at:
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/
"Timothy Ross" <ross_timothy@.hotmail.com> wrote in message news:eZSyPiVhEHA.1652@.TK2MSFTNGP0
9.phx.gbl...
> Steve,
> Thank you for these instructions - we are not using replicaton and we have
> manual backups of all the databases - I will use your instructions.
> TR
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:e9sYzQVhEHA.1356@.TK2MSFTNGP09.phx.gbl...
> way
> a
>|||Thanks Tibor -- far more complete!
Steve
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OVnhWDWhEHA.1356@.TK2MSFTNGP09.phx.gbl...
> You might want to check my article at:
> 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/
>
> "Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
news:eZSyPiVhEHA.1652@.TK2MSFTNGP09.phx.gbl...
have[vbcol=seagreen]
best[vbcol=seagreen]
"renaming[vbcol=seagreen]
have[vbcol=seagreen]
you[vbcol=seagreen]
there[vbcol=seagreen]
>|||Thank you Tibor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OVnhWDWhEHA.1356@.TK2MSFTNGP09.phx.gbl...
> You might want to check my article at:
> 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/
>
> "Timothy Ross" <ross_timothy@.hotmail.com> wrote in message
news:eZSyPiVhEHA.1652@.TK2MSFTNGP09.phx.gbl...
have[vbcol=seagreen]
best[vbcol=seagreen]
"renaming[vbcol=seagreen]
have[vbcol=seagreen]
you[vbcol=seagreen]
there[vbcol=seagreen]
>