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...
> > Hi,
> >
> > I have rename my WindowsXP after I installing the SqlServer 2005 express.
> >
> > Can the SqlServer run well in the WindowsXP after renaming?
> >
> >
>
>|||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...
>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...
>> > Hi,
>> >
>> > I have rename my WindowsXP after I installing the SqlServer 2005
>> > express.
>> >
>> > Can the SqlServer run well in the WindowsXP after renaming?
>> >
>> >
>>