changing sql server name

Hi
The name of my sql server has an underscore in it and I need to get rid of
it in order to set up replication. BOL is a bit unclear as do I have to
change the name of the pc first of all (which also has underscore in name)
and then run sp_dropserver and sp_addserver. Really, my question is it
possible to rename sql server without first changing the name of the pc? So
can I just use the 2sp's without changing the name of the pc?
Thanks
Jonjo
Hi
You need to rename the PC. sp_dropserver and sp_addserver are there to fix
up the row in Master where the SQL Server queries to find out about itself.
It does not change the network name.
Regards
Mike
"jonjo" wrote:

> Hi
> The name of my sql server has an underscore in it and I need to get rid of
> it in order to set up replication. BOL is a bit unclear as do I have to
> change the name of the pc first of all (which also has underscore in name)
> and then run sp_dropserver and sp_addserver. Really, my question is it
> possible to rename sql server without first changing the name of the pc? So
> can I just use the 2sp's without changing the name of the pc?
> Thanks
> Jonjo

changing sql server name

Hi
The name of my sql server has an underscore in it and I need to get rid of
it in order to set up replication. BOL is a bit unclear as do I have to
change the name of the pc first of all (which also has underscore in name)
and then run sp_dropserver and sp_addserver. Really, my question is it
possible to rename sql server without first changing the name of the pc? So
can I just use the 2sp's without changing the name of the pc?
Thanks
JonjoHi
You need to rename the PC. sp_dropserver and sp_addserver are there to fix
up the row in Master where the SQL Server queries to find out about itself.
It does not change the network name.
Regards
Mike
"jonjo" wrote:

> Hi
> The name of my sql server has an underscore in it and I need to get rid of
> it in order to set up replication. BOL is a bit unclear as do I have to
> change the name of the pc first of all (which also has underscore in name)
> and then run sp_dropserver and sp_addserver. Really, my question is it
> possible to rename sql server without first changing the name of the pc? S
o
> can I just use the 2sp's without changing the name of the pc?
> Thanks
> Jonjo

changing sql server name

Hi
The name of my sql server has an underscore in it and I need to get rid of
it in order to set up replication. BOL is a bit unclear as do I have to
change the name of the pc first of all (which also has underscore in name)
and then run sp_dropserver and sp_addserver. Really, my question is it
possible to rename sql server without first changing the name of the pc? So
can I just use the 2sp's without changing the name of the pc?
Thanks
JonjoHi
You need to rename the PC. sp_dropserver and sp_addserver are there to fix
up the row in Master where the SQL Server queries to find out about itself.
It does not change the network name.
Regards
Mike
"jonjo" wrote:
> Hi
> The name of my sql server has an underscore in it and I need to get rid of
> it in order to set up replication. BOL is a bit unclear as do I have to
> change the name of the pc first of all (which also has underscore in name)
> and then run sp_dropserver and sp_addserver. Really, my question is it
> possible to rename sql server without first changing the name of the pc? So
> can I just use the 2sp's without changing the name of the pc?
> Thanks
> Jonjo