Post reply

Need to change the owner of database package

  • October 7, 2008 at 10:26 am

    #194096

    Hello,

    I just need to change the owner for the database package, can I please get the assistance in regard to this,

    Thanks,

    Dev

  • October 7, 2008 at 12:32 pm

    #881889

    Hi,

    Can you provide specifics? I'm not sure what you mean by "database package."

    Are you trying to change the owner of a Database, a DTS or SSIS package or a schema?

    Chris.

    Chris.

  • October 7, 2008 at 12:38 pm

    #881892

    Sorry it DTS Package

  • October 7, 2008 at 12:42 pm

    #881895

    Thats better. 🙂

    Out of curiosity, why do you want to change the owner of the package? As far as I know this doesn't actually mean anything.

    Chris.

    Chris.

  • October 7, 2008 at 12:44 pm

    #881898

    Hello Chris,

    The job associated is failing, the DTS package is under user name with read privelages, I wanted to change that,

    Please Advice,

    Thanks,

    Dev

  • October 7, 2008 at 1:00 pm

    #881912

    Ok, thats what I suspected. The owner of the DTS package isn't important in this case, its the job owner that is.

    From Enterprise Manager open Management | SQL Server Agent | Jobs and navigate to your job. Double click on it and change the owner here.

    Chris.

    Chris.

  • October 7, 2008 at 1:15 pm

    #881926

    Anyway if you want to still change the owner of DTS package then use undocumented SP in MSDB to do it (sp_reassign_dtspackageowner [@name =] 'name',

    [@id =] 'id',

    [@newloginname =] 'newloginname'

Viewing 7 posts - 1 through 6 (of 6 total)

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