Change Ownership of a Maintenance Plan

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


    Phill Carter

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

  • -- For 2005, here is a simple script:

    use msdb;

    go

    updatedbo.sysdtspackages90

    setownersid = (

    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 2 (of 2 total)

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