Help when renaming server

Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. SmithHi
Look at sp_dropserver and sp_addserver in the BOL.
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.
TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. Smith|||Hi
After having renamed the server, you just need to run sp_dropserver and then
sp_addserver. You can look up the syntax in BOL.
Regards
Steen
"Mr. Smith" <nospam@.blindfolded.gone> skrev i en meddelelse news:uB9V6KYGFHA
.444@.TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs our precious SQL 7.0 server. I guess there are some
issues I have to deal with afterwards to get the database engine up and abo
ut. Do any of you have good resources (URL's) or other information which you
may share with me, to enable us rename our server without to much hassle. P
lease.
Bst Regards
Mr. Smith|||There's more to it than only sp_dropserver and sp_addserver. Especially for
a 7.0 SQL Server. Check
out http://www.karaszi.com/SQLServer/in...server_name.asp for more in
formation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mr. Smith" <nospam@.blindfolded.gone> wrote in message news:uB9V6KYGFHA.444@.
TK2MSFTNGP15.phx.gbl...
Hi.
Due to corporate guidelines we are "forced" to change the name of our Window
s 2000 server which runs
our precious SQL 7.0 server. I guess there are some issues I have to deal wi
th afterwards to get the
database engine up and about. Do any of you have good resources (URL's) or o
ther information which
you may share with me, to enable us rename our server without to much hassle
. Please.
Bst Regards
Mr. Smith|||Thanks Tibor.
The URL whas just what I needed.
Mr. Smith
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eYs%235vYGFHA.3732@.TK2MSFTNGP14.phx.gbl...
> There's more to it than only sp_dropserver and sp_addserver. Especially
for a 7.0 SQL Server. Check
> out http://www.karaszi.com/SQLServer/in...server_name.asp for more
information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:uB9V6KYGFHA.444@.TK2MSFTNGP15.phx.gbl...
> Hi.
> Due to corporate guidelines we are "forced" to change the name of our
Windows 2000 server which runs
> our precious SQL 7.0 server. I guess there are some issues I have to deal
with afterwards to get the
> database engine up and about. Do any of you have good resources (URL's) or
other information which
> you may share with me, to enable us rename our server without to much
hassle. Please.
>
> Bst Regards
> Mr. Smith
>