Hi.
Some facts first:
Win2003 64-bit and SQL2000 64 bit on 3 Cluster nodes
Q:
I have to do Deligation of DTS Pakages to the Developers without giving them
sa rights. I have read the the following pages:
http://eddorre.com/comments.aspx?post_id=204
http://www.sqldts.com/default.aspx?212 ( how do i remove the checks from the
stored procedure? it dosen't say?)
But wich one of these solutions are best?
I Want the developers to ADD Change and Delete any Pakage they want with
out getting a DBA/SA to do it for them??? I am using Domain groups to all
Developers.

Best Regards

In message <96E17C5D-6761-4B3F-ABDB-1BBD97F41523 (AT) microsoft (DOT) com>, Baldini
<Baldini (AT) discussions (DOT) microsoft.com> writes
Look for the line -

IF (@owner_sid <> SUSER_SID() AND (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'),
0) <> 1))

Remove the test for sa role membership. If you don't understand this
then I don't recommend you attempt what is an unsupported hack.


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

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

Even if you do understand this, I am not sure I would do it. As Darren
points out it is unsupported.

Rand
This posting is provided "as is" with no warranties and confers no rights.