Saving pkgs when not the owner or sysadmin

#1

Is there a way to save new versions of packages when you
are not the owner of the package or a member of sysadmin?

For instance I have a package that was created by another
person, but we want to be able to both edit the package.
Neither of us are members of sysadmin.

Thanks in advance.

#2

In message <11cbd01c3f643$b5c84ab0$a101280a (AT) phx (DOT) gbl>, Sue
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Is there a way to save new versions of packages when you
are not the owner of the package or a member of sysadmin?

For instance I have a package that was created by another
person, but we want to be able to both edit the package.
Neither of us are members of sysadmin.

Thanks in advance.
No. This check is coded into the system stored procedures for DTS

Or

Get a sysadmin to hack the sp_add_dtspackage and remove the check. I do
this on Dev boxes quite happily. You could even add your own custom code
to enforce groups and similar.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Saving pkgs when not the owner or sysadmin

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Saving pkgs when not the owner or sysadmin - 02-18-2004 , 11:21 AM

Re: Saving pkgs when not the owner or sysadmin - 02-18-2004 , 11:29 AM