Hiya,

What I want to do is be able to save over another users
DTS package where their username is the owner.

I dont want to have to 'save as' a different name then
delete the original and rename my one, as there is quite a
lot to do.

Is there specific permissions I can get granted to allow
me to overwrite someone else's DTS package except
sysadmin??

Thanks
Wendy

In message <083f01c49fc2$36965470$a601280a (AT) phx (DOT) gbl>, Wendy
<anonymous (AT) discussions (DOT) microsoft.com> writes
You could hack the sp_add_dtspackage stored procedure to remove the
sysadmin role check. This works for me on all dev boxes where developers
need to co-author packages, yet they are not always sysadmins.

If you can delete the original, then open it, delete the original, then
save again. Enterprise Manager will keep the "open" package in memory
for you. Not ideal, but faster than the Save As times two.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

You can find information on the topic and ways to change the
package owner in the following article on sqldts.com:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212

-Sue

On Tue, 21 Sep 2004 03:03:16 -0700, "Wendy"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: