• Thanks for sharing.

    Just wanna add one note about the code for

    changing the Maintenance plan ownership :

    use msdb;

    go

    update dbo.sysssispackages

    set ownersid = (

    select sid from msdb.sys.syslogins where name = 'sa')

    where [name] = 'MaintenancePlanNameHere';

    It only works for SQL2008 because there is no dbo.sysssispackages in the MSDB in SQL2005. Use dbo.sysdtspackages90 in SQL 2005.