Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Change Ownership of a Maintenance Plan

    -- 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...

Viewing post 1 (of 1 total)