Local Packages

• Paul Hoang

  SSC Rookie

  Points: 45

  More actions

  July 14, 2005 at 5:56 pm

  #167585

  Need your help.

  Is there any way I can change owner of Local packages on SQL2000

  I user SP_changeobjectowner but it won't work.

  Thank you for all your help.

  Paul

   

   

   

• ND-215452

  SSCrazy

  Points: 2037

  More actions

  July 14, 2005 at 6:34 pm

  #574634

  in msdb

  exec sp_DTSReplaceOwner oldowner, newowner

• ND-215452

  SSCrazy

  Points: 2037

  More actions

  July 14, 2005 at 8:04 pm

  #574652

  actually use this:

   sp_reassign_dtspackageowner