更改Maintenance Plan或SSIS package的owner

  • 828
  • 0

摘要:更改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')