Change Ownership of a Maintenance Plan

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Phill Carter » Change Ownership of a Maintenance Plan

Change Ownership of a Maintenance Plan

Rate Topic

Display Mode

Topic Options

Author

Message

Phill Carter

Posted Saturday, December 13, 2008 6:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:25 PM
Points: 6, Visits: 102

Comments posted to this topic are about the item Change Ownership of a Maintenance Plan

Phill Carter

Post #619202

a-848662

Posted Wednesday, December 31, 2008 2:04 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 10:22 AM
Points: 26, Visits: 3,729

For any SQL 2005 guys who stumble upon this one: IN 2005 it's msdb.dbo.sysdtspackages90.

Post #627889

Don Norman

Posted Monday, August 24, 2009 1:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:59 AM
Points: 1, Visits: 28

-- For 2005, here is a simple script:

use msdb;
go
update dbo.sysdtspackages90
set ownersid = (
select sid from msdb.sys.syslogins where name = 'LoginNameHere')
where [name] = 'MaintenancePlanNameHere';
--------------------------------------
-- and for 2000,
use msdb;
go
update sysdbmaintplans
set owner = 'LoginNameHere'
where plan_name = 'MaintenancePlanNameHere';

Post #776254

« Prev Topic | Next Topic »

Permissions