Im trying to change the owership of the DTS package but am a little
confused.
sp_changeobjectowner changes the ownership of table, view, or stored
procedure in the current database...
How could i change the DTS package ownership?
Thank you in advance.
Leo
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Leo Kozhushnik <anonymous@.devdex.com> wrote in message news:<3f1390c1$0$202$75868355@.news.frii.net>...
> Hello there,
> Im trying to change the owership of the DTS package but am a little
> confused.
> sp_changeobjectowner changes the ownership of table, view, or stored
> procedure in the current database...
> How could i change the DTS package ownership?
> Thank you in advance.
> Leo
In most cases, it doesn't really matter who owns the package - who is
executing it is more important. However, there is an undocumented
stored procedure called msdb..sp_reassign_dtspackageowner, which you
can use.
You might want to look at http://www.sqldts.com - in the
Administration and Management section of the FAQ, there is an article
on package ownership issues, including a wrapper procedure for
sp_reassign_dtspackageowner.
Of course, since this procedure is undocumented, you should be careful
using it, and preferably never in production code - its behaviour may
change in future releases with no warning.
Simon|||Leo Kozhushnik <anonymous@.devdex.com> wrote in message news:<3f1390c1$0$202$75868355@.news.frii.net>...
> Hello there,
> Im trying to change the owership of the DTS package but am a little
> confused.
> sp_changeobjectowner changes the ownership of table, view, or stored
> procedure in the current database...
> How could i change the DTS package ownership?
> Thank you in advance.
> Leo
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
Hi Leo, use the undocumented SP:
sp_reassign_dtspackageowner [@.name =] 'name',
[@.id =] 'id',
[@.newloginname =] 'newloginname'
[@.name =] 'name'
The package name.
[@.id =] 'id'
This is the uniqueidentifier for the package. A name may not
necessarily be unique.
[@.newloginname =] 'newloginname'
The new Owner name. SQL Server login example 'sa', NT Integrated
example 'Domain\Username'
Regards,
Thomas
http://www.sqlscripter.com
