Rename Server

Help please. Not very up on SQL server. Hopefully this is
a simple one. If SQL server 2000 is installed on an W2k
member server can there be any complications re-naming the
server or will SQL have problems.
Regards
GraemeAfter NT renaming, do:
sp_dropserver <oldname>
sp_addserver <newname>, LOCAL
And I think that you have to redo replication, if you have such...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Graeme Lockhart" <graeme.lockhart@.scotland.gsi.gov.uk> wrote in message
news:0b8d01c366e5$2184ef90$a101280a@.phx.gbl...
> Help please. Not very up on SQL server. Hopefully this is
> a simple one. If SQL server 2000 is installed on an W2k
> member server can there be any complications re-naming the
> server or will SQL have problems.
> Regards
> Graeme|||To add to Tibor's post, if you have created any jobs under the old name you
will have to change the originating server in sysjobs to the new name.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Graeme Lockhart" <graeme.lockhart@.scotland.gsi.gov.uk> wrote in message
news:0b8d01c366e5$2184ef90$a101280a@.phx.gbl...
> Help please. Not very up on SQL server. Hopefully this is
> a simple one. If SQL server 2000 is installed on an W2k
> member server can there be any complications re-naming the
> server or will SQL have problems.
> Regards
> Graeme