Box name and default SQL Server name

I had created SQL 2000 on Win 2000 with the default box
name. What happens to SQL 2000's default name if the
box's name gets changed in future ? Will it also take up
the new name of the box?
ThanksHi,
No, You have drop and create the server name.
Look into sp_dropserver ,sp_addserver in Bol.
Thanks
Hari
MCDBA
"kanthi" <anonymous@.discussions.microsoft.com> wrote in message
news:023701c3b103$22e83f50$a001280a@.phx.gbl...
> I had created SQL 2000 on Win 2000 with the default box
> name. What happens to SQL 2000's default name if the
> box's name gets changed in future ? Will it also take up
> the new name of the box?
> Thanks|||I had a problem because of this and got help off some forum It caused me
problems with an existing replication subscription here is what had to do
to fix it.
In QA use SELECT @.@.ServerName
This will show you the stored SQL servername (It will be your old one)
Then use sp_dropserver 'YourOldServerName', 'droplogins'
Stop and re-start SQL Server
Then do SELECT @.@.ServerNAme again in QA
This should return a null
Then use sp_addserver 'NewServerName', 'local'
Make sure the local parameter is there !
Stop and re-start SQL Server again
Then use SELECT @.@.ServerName again in QA
This should now be your new server name
Hope this helps
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ODplQtQsDHA.572@.TK2MSFTNGP11.phx.gbl...
> Hi,
> No, You have drop and create the server name.
> Look into sp_dropserver ,sp_addserver in Bol.
> Thanks
> Hari
> MCDBA
>
> "kanthi" <anonymous@.discussions.microsoft.com> wrote in message
> news:023701c3b103$22e83f50$a001280a@.phx.gbl...
> > I had created SQL 2000 on Win 2000 with the default box
> > name. What happens to SQL 2000's default name if the
> > box's name gets changed in future ? Will it also take up
> > the new name of the box?
> >
> > Thanks
>