After computer name changed ...

Hi,
We have database server that runs on SQL Server 2000
Enterprise Edition with SP3.
The computer name changed from DEVA-DB09 to DEVB-DB09.
Now, when I issue the command select @.@.servername in SQL
Query Analyzer, it returned DEVA-DB09, but the computer
name is DEVB-DB09. So my scheduling jobs cannot add,
update, or delete.
In SQL Query Analyzer I issue the following command:
DECLARE @.srv sysname
SET @.srv = CAST(SERVERPROPERTY ('Servername') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
Now I can add, update, or delete the scheduling jobs. My
question is: How can I change the SQL Server name from
DEVA-DB09 to DEVB-DB09 when I issue the select
@.@.servername.
Thanks,
-Jenny
You might want to check into the issues note in this KB article:
http://support.microsoft.com/default...74&Product=sql
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Jenny" <jyu@.iseoptions.com> wrote in message
news:14ee01c499b9$dcc67690$a301280a@.phx.gbl...
> Hi,
> We have database server that runs on SQL Server 2000
> Enterprise Edition with SP3.
> The computer name changed from DEVA-DB09 to DEVB-DB09.
> Now, when I issue the command select @.@.servername in SQL
> Query Analyzer, it returned DEVA-DB09, but the computer
> name is DEVB-DB09. So my scheduling jobs cannot add,
> update, or delete.
> In SQL Query Analyzer I issue the following command:
> DECLARE @.srv sysname
> SET @.srv = CAST(SERVERPROPERTY ('Servername') AS sysname)
> UPDATE sysjobs SET originating_server = @.srv
> Now I can add, update, or delete the scheduling jobs. My
> question is: How can I change the SQL Server name from
> DEVA-DB09 to DEVB-DB09 when I issue the select
> @.@.servername.
> Thanks,
> -Jenny
>
|||Try this out..run on your mastr db and restart SQL server services...
sp_dropserver 'DEVA-DB09'
go
sp_addserver 'DEVB-DB09'
go
-Nilay
"Jenny" wrote:

> Hi,
> We have database server that runs on SQL Server 2000
> Enterprise Edition with SP3.
> The computer name changed from DEVA-DB09 to DEVB-DB09.
> Now, when I issue the command select @.@.servername in SQL
> Query Analyzer, it returned DEVA-DB09, but the computer
> name is DEVB-DB09. So my scheduling jobs cannot add,
> update, or delete.
> In SQL Query Analyzer I issue the following command:
> DECLARE @.srv sysname
> SET @.srv = CAST(SERVERPROPERTY ('Servername') AS sysname)
> UPDATE sysjobs SET originating_server = @.srv
> Now I can add, update, or delete the scheduling jobs. My
> question is: How can I change the SQL Server name from
> DEVA-DB09 to DEVB-DB09 when I issue the select
> @.@.servername.
> Thanks,
> -Jenny
>
>
|||Actually try this:
SP_DropServer 'DEVA-DB09'
Go
SP_AddServer 'DEVB-DB09','Local'
Go
HTH
Saleem@.sqlnt.com
"NT" wrote:
[vbcol=seagreen]
> Try this out..run on your mastr db and restart SQL server services...
> sp_dropserver 'DEVA-DB09'
> go
> sp_addserver 'DEVB-DB09'
> go
> -Nilay
> "Jenny" wrote:

After computer name changed ...

Hi,
We have database server that runs on SQL Server 2000
Enterprise Edition with SP3.
The computer name changed from DEVA-DB09 to DEVB-DB09.
Now, when I issue the command select @.@.servername in SQL
Query Analyzer, it returned DEVA-DB09, but the computer
name is DEVB-DB09. So my scheduling jobs cannot add,
update, or delete.
In SQL Query Analyzer I issue the following command:
DECLARE @.srv sysname
SET @.srv = CAST(SERVERPROPERTY ('Servername') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
Now I can add, update, or delete the scheduling jobs. My
question is: How can I change the SQL Server name from
DEVA-DB09 to DEVB-DB09 when I issue the select
@.@.servername.
Thanks,
-JennyYou might want to check into the issues note in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303774&Product=sql
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Jenny" <jyu@.iseoptions.com> wrote in message
news:14ee01c499b9$dcc67690$a301280a@.phx.gbl...
> Hi,
> We have database server that runs on SQL Server 2000
> Enterprise Edition with SP3.
> The computer name changed from DEVA-DB09 to DEVB-DB09.
> Now, when I issue the command select @.@.servername in SQL
> Query Analyzer, it returned DEVA-DB09, but the computer
> name is DEVB-DB09. So my scheduling jobs cannot add,
> update, or delete.
> In SQL Query Analyzer I issue the following command:
> DECLARE @.srv sysname
> SET @.srv = CAST(SERVERPROPERTY ('Servername') AS sysname)
> UPDATE sysjobs SET originating_server = @.srv
> Now I can add, update, or delete the scheduling jobs. My
> question is: How can I change the SQL Server name from
> DEVA-DB09 to DEVB-DB09 when I issue the select
> @.@.servername.
> Thanks,
> -Jenny
>|||Actually try this:
SP_DropServer 'DEVA-DB09'
Go
SP_AddServer 'DEVB-DB09','Local'
Go
HTH
Saleem@.sqlnt.com
"NT" wrote:
> Try this out..run on your mastr db and restart SQL server services...
> sp_dropserver 'DEVA-DB09'
> go
> sp_addserver 'DEVB-DB09'
> go
> -Nilay
> "Jenny" wrote:
> > Hi,
> >
> > We have database server that runs on SQL Server 2000
> > Enterprise Edition with SP3.
> >
> > The computer name changed from DEVA-DB09 to DEVB-DB09.
> > Now, when I issue the command select @.@.servername in SQL
> > Query Analyzer, it returned DEVA-DB09, but the computer
> > name is DEVB-DB09. So my scheduling jobs cannot add,
> > update, or delete.
> >
> > In SQL Query Analyzer I issue the following command:
> >
> > DECLARE @.srv sysname
> > SET @.srv = CAST(SERVERPROPERTY ('Servername') AS sysname)
> > UPDATE sysjobs SET originating_server = @.srv
> >
> > Now I can add, update, or delete the scheduling jobs. My
> > question is: How can I change the SQL Server name from
> > DEVA-DB09 to DEVB-DB09 when I issue the select
> > @.@.servername.
> >
> > Thanks,
> > -Jenny
> >
> >
> >