摘要:更改Maintenance Plan或SSIS package的owner
SELECT
name, ,suser_sname(ownersid)as OwnerName , ownersid
FROM
msdb.dbo.sysssispackages
UPDATE
msdb.dbo.sysssispackages
SET
OWNERSID = SUSER_SID('新Owner)
WHERE
OWNERSID = SUSER_SID('舊Owner')