Home Forums Article Discussions Article Discussions by Author Discuss content posted by Shashank Srivastava Change the Maintenance Plan Owner RE: Change the Maintenance Plan Owner
Michael Valentine Jones
SSC Guru
Points: 64818
More actions
July 2, 2013 at 11:38 am
#1629231
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