• For 2005, 2008, or 2008 R2, you should check column packagetype=6 to make sure you are only updating maintenance plan packages.

    The script below works with 2005, 2008, or 2008 R2 maintenance plans.

    Change Maintenance Plan Owner

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164441