Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change Ownership of a Maintenance Plan Expand / Collapse
Author
Message
Posted Saturday, December 13, 2008 6:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 3:21 AM
Points: 11, Visits: 139
Comments posted to this topic are about the item Change Ownership of a Maintenance Plan


Phill Carter
Post #619202
Posted Wednesday, December 31, 2008 2:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 3, 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
Posted Monday, August 24, 2009 1:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse