After rename the computer

Hi,
I have rename my WindowsXP after I installing the SqlServer 2005 express.
Can the SqlServer run well in the WindowsXP after renaming?you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:

> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>
>|||you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:

> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...[vbcol=seagreen]
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...[vbcol=seagreen]
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>