all groups > sql server dts > june 2007 >
You're in the

sql server dts

group:

How could I permit another user to change my DTS?



How could I permit another user to change my DTS? Geri Reshef
6/28/2007 7:20:43 AM
sql server dts: When another user try to work with my DTS he receives the following message:
"only the owner of dts package 'MyDTS' or a member of the sysadmin role may
drop it or any of its versions"
How could I let him work with it without making him a Sysadmin? (For
example- how could I change the owner of the DTS?)

I found by my self: msdb..sp_reassign_dtspackageowner Geri Reshef
6/28/2007 7:33:19 AM
:-)

AddThis Social Bookmark Button