Hi, we have a user that create some dts packages. He is the owner of the
pachages. He try to do some changes after saving them, but when try to
save the changes a message is displayed:

Onlye members of the sysadmin server role can change the dts or the
owner.

He is the owner, but he canno´t change it.

How can i resolve this problem without adding to the sysadmin server
role??

thanks a lot for your help.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In message <eNNTO644EHA.1404 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, MariaGuzman
<marisa (AT) devdex (DOT) com> writes
Personally I would hack the system proc and remove the sysadmin roll
check. sp_adddtspackage or similar in msdb.

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

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