SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Phill Carter / Change Ownership of a Maintenance Plan / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:41:42 GMT20RE: Change Ownership of a Maintenance Planhttp://www.sqlservercentral.com/Forums/Topic619202-1435-1.aspx-- For 2005, here is a simple script:use msdb;goupdate dbo.sysdtspackages90set ownersid = ( select sid from msdb.sys.syslogins where name = 'LoginNameHere')where [name] = 'MaintenancePlanNameHere';---------------------------------------- and for 2000, use msdb;goupdate sysdbmaintplansset owner = 'LoginNameHere'where plan_name = 'MaintenancePlanNameHere';Mon, 24 Aug 2009 13:01:26 GMTDon NormanRE: Change Ownership of a Maintenance Planhttp://www.sqlservercentral.com/Forums/Topic619202-1435-1.aspxFor any SQL 2005 guys who stumble upon this one: IN 2005 it's msdb.dbo.sysdtspackages90.Wed, 31 Dec 2008 02:04:19 GMTa-848662Change Ownership of a Maintenance Planhttp://www.sqlservercentral.com/Forums/Topic619202-1435-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Ownership/65227/">Change Ownership of a Maintenance Plan</A>[/B]Sat, 13 Dec 2008 18:38:11 GMTPhill Carter