Renaming a SQL Server Instance

Hi
I'm relatively new to SQL Server 2000. Until recently we
were predominatly an Oracle DB Site, so most of our skills
are in Oracle.
We are trying to colsolodate a number of SQL Server
Instances.
Is there an easy way to rename a SQL Server Instance.
Beyond, Intalling the new instance, copyingHi
You can used sp_dropserver and sp_addserver
see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
Make sure you use the local parameter in sp_addserver.
John
"Bev Brindle" <BeverleyBrindle@.barcalys.co.uk> wrote in message
news:22bd001c38be5$87704780$a601280a@.phx.gbl...
> Hi
> I'm relatively new to SQL Server 2000. Until recently we
> were predominatly an Oracle DB Site, so most of our skills
> are in Oracle.
> We are trying to colsolodate a number of SQL Server
> Instances.
> Is there an easy way to rename a SQL Server Instance.
> Beyond, Intalling the new instance, copying|||To add to John's post, this is an excellent link I borrowed from a Dejan
Sarka post on renaming SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;257716.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Bev Brindle" <BeverleyBrindle@.barcalys.co.uk> wrote in message
news:22bd001c38be5$87704780$a601280a@.phx.gbl...
> Hi
> I'm relatively new to SQL Server 2000. Until recently we
> were predominatly an Oracle DB Site, so most of our skills
> are in Oracle.
> We are trying to colsolodate a number of SQL Server
> Instances.
> Is there an easy way to rename a SQL Server Instance.
> Beyond, Intalling the new instance, copying