| Author |
Change of Computer Name
|
|
| Desmond 2005-06-29, 3:23 am |
| 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
| |
| Uri Dimant 2005-06-29, 3:23 am |
| 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@microso
ft.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
| |
| Tibor Karaszi 2005-06-29, 3:23 am |
| http://www.karaszi.com/SQLServer/ i...n
ame.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@microso
ft.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
| |
| John Bell 2005-06-29, 3:23 am |
| Hi
This is SQL 2000 but I think it may have been the same in SQL 7.
http://msdn.microsoft.com/library/d...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
|
|
|
|