sp_reassign_dtspackageowner

  • use msdb

    exec sp_reassign_dtspackageowner

    @name = 'DBCC_DBREINDEX_CM_DTS' , @ID= 'B3AE1271268640F89A5050C611B771B9', @newloginname = 'DBA'

    what's wrong with my snytax????

  • What's your error message?

    or

    try this id with hyphens = 'B3AE1271-2686-40F8-9A50-50C611B771B9'

    _____________
    Donn Policarpio

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

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