SQL 2000 changed server name and then agent job failed

Can't edit agent job

SQL 2000 14274的圖片搜尋結果

use msdb

go

update dbo.sysjobs set originating_server = 'CorrectServerName'

 

Can't add correct windows users with domain name

SQL 15401的圖片搜尋結果

because same sid, need to delete old login

發佈留言

*