Change of Computer Name

Hi,
I'll like to change the computer name but my sql server 7 instance is tied
to the computer name. May I know how to resolve this without re-installation ?
TIA !
Desmond
Desmond
See sp_addserver and sp_dropserver in the BOL as well as visit at this web
site
http://vyaskn.tripod.com/moving_sql_server.htm
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without
re-installation ?
> TIA !
> Desmond
|||http://www.karaszi.com/SQLServer/inf...erver_name.asp
Note that you have to adapt the SQL code that handles your jobs (the code is to SQL Server 2000)...
Or use the KB article strategy instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installation ?
> TIA !
> Desmond
|||Hi
This is SQL 2000 but I think it may have been the same in SQL 7.
http://msdn.microsoft.com/library/de...stall_5r8f.asp
John
"Desmond" wrote:

> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installation ?
> TIA !
> Desmond

Change of Computer Name

Hi,
I'll like to change the computer name but my sql server 7 instance is tied
to the computer name. May I know how to resolve this without re-installation
?
TIA !
DesmondDesmond
See sp_addserver and sp_dropserver in the BOL as well as visit at this web
site
http://vyaskn.tripod.com/moving_sql_server.htm
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without
re-installation ?
> TIA !
> Desmond|||http://www.karaszi.com/SQLServer/in...server_name.asp
Note that you have to adapt the SQL code that handles your jobs (the code is
to SQL Server 2000)...
Or use the KB article strategy instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installati
on ?
> TIA !
> Desmond|||Hi
This is SQL 2000 but I think it may have been the same in SQL 7.
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
John
"Desmond" wrote:

> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installati
on ?
> TIA !
> Desmond

Change of Computer Name

Hi,
I'll like to change the computer name but my sql server 7 instance is tied
to the computer name. May I know how to resolve this without re-installation ?
TIA !
DesmondDesmond
See sp_addserver and sp_dropserver in the BOL as well as visit at this web
site
http://vyaskn.tripod.com/moving_sql_server.htm
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without
re-installation ?
> TIA !
> Desmond|||http://www.karaszi.com/SQLServer/info_change_server_name.asp
Note that you have to adapt the SQL code that handles your jobs (the code is to SQL Server 2000)...
Or use the KB article strategy instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Desmond" <Desmond@.discussions.microsoft.com> wrote in message
news:314C7E9C-FFC8-4651-B085-B1BD74A84B3B@.microsoft.com...
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installation ?
> TIA !
> Desmond|||Hi
This is SQL 2000 but I think it may have been the same in SQL 7.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
John
"Desmond" wrote:
> Hi,
> I'll like to change the computer name but my sql server 7 instance is tied
> to the computer name. May I know how to resolve this without re-installation ?
> TIA !
> Desmond