Howdo I change the ownership of DTS packages?
Thanks
In the msdb database there is stored procedure named
sp_reassign_dtspackageowner that will help you change it.
Here is a sample syntax:
msdb..sp_reassign_dtspackageowner
@.name = 'Package Name',
@.id = '-7DED-11D4-BF04-00B0D057DBE4',
@.newloginname = 'new user'
You can get the package ID (@.id) from the msdb..sysdtspackages table (ID
column).
"Mecn" wrote:
> Howdo I change the ownership of DTS packages?
> Thanks
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment