Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  DTS persmissions

Author  Topic  mvander Starting Member 4 Posts Posted - 2002-04-26 : 14:35:05 I have several SQL 2000 servers. On these severs there are multiple small databases that are for purchased apps. I am the central admin, but some of these databases have their own dba. These DBAs have their own DTS jobs. How can give these DBAs correct persmissions to create and schedule their DTS packages and have access to the SQL Agent jobs without making them system admins? Thanks in advance,