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...
> > 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
>|||You might want to check my article at:
http://www.karaszi.com/SQLServer/info_change_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...
> 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...
> > > 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
> >
> >
>|||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/info_change_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...
> > 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...
> > > > 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
> > >
> > >
> >
> >
>|||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/info_change_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...
> > 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...
> > > > 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
> > >
> > >
> >
> >
>