Change Ownership of a Maintenance Plan

  • Phill Carter

    SSC Enthusiast

    Points: 119

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


    Phill Carter

  • a-848662

    Old Hand

    Points: 322

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

  • Don Norman

    Valued Member

    Points: 73

    -- 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';

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply