I had to change my SQL box machine name and I used the following script. Note that I have SQL 2000.USE MASTERGOsp_dropserver OldMachineName -- Old Machine NameGOsp_addserver NewMachineName, LOCAL -- New Machine NameGO--allow updates to system catalogsexec sp_configure 'allow updates', 1reconfigure with override--update sysjobsUSE msdbGOupdate sysjobs set originating_server = 'OldMachineName' -- Old Machine Namewhere originating_server = 'NewMachineName' -- New Machine Name--disallow updates to system catalogsexec sp_configure 'allow updates', 0reconfigure with overrideGO
Canada DBA