|
select * from sysservers
sp_dropserver 'KBARTLETTXP'
Go
sp_addserver 'RHORKAYXP','local'
go
-- SYSJOBS, http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281642
/*
If this is a SQL2000, you need to change the originating_server column in
msdb..sysjobs table.Details here:
PRB: Error 14274 Occurs When You Update a SQL Agent Job After Renaming
Windows Server
*/
select * from msdb..sysjobs
update msdb..sysjobs
set originating_server = 'rhorkayxp'
where originating_server = 'kbartlettxp'
|