Friday, March 9, 2012

Ownership of the DTS

How can we change the ownership of a DTS package ?
ThanksHi,
In MSDB database there is a undocumented procedure
sp_reassign_dtspackageowner
Details are in below link:-
http://www.sqldts.com/default.aspx?6,105,212,0,1
--
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2089b01c459b4$88bd28e0$a301280a@.phx.gbl...
> How can we change the ownership of a DTS package ?
> Thanks|||Peter
EXEC msdb.dbo.sp_DTSReplaceOwner
@.old_owner='Peter',
@.new_owner='sa'
Also
http://support.microsoft.com/default.aspx?scid=kb;EN-US;247052
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2089b01c459b4$88bd28e0$a301280a@.phx.gbl...
> How can we change the ownership of a DTS package ?
> Thanks

No comments:

Post a Comment