SQL 2000 changed server name and then agent job failed 2019-12-20 作者: Tim Ng Can't edit agent job use msdb go update dbo.sysjobs set originating_server = 'CorrectServerName' Can't add correct windows users with domain name because same sid, need to delete old login