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
Posted inMSSQL
SQL 2000 changed server name and then agent job failed
Posted by
No Comments
No Comments