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.
| Author |
Topic |
|
TonyTheDBA
Posting Yak Master
121 Posts |
 Posted - 2006-05-15 : 07:29:08
|
Just what it says really.Is Enterprise Manager the only tool for creating and editing DTS packages in SQL Server 2000?I have a group of users in another Dept that need to have the ability to write DTS packages, and they were given Access to Enterprise manager to do so, however they have discovered that they can use it to do other things  The manager of the other department thinks that it is ok for them to do this, and I don't get enough backup from my management (We must keep the customers happy).Does anyone know if there are any other DTS design tools out there? Failing that is there anyway of disabling parts of the Enterprise Manager mmc plugin to prevent inappropriate use of the other parts of EM?-- RegardsTony The DBA |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-15 : 07:30:40
|
| They can only use the other parts of EM if they have permission to do so. Deny access to the relevant areas on the server.-------Moo. :) |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-15 : 23:04:00
|
or provide them with another box to "play" around, then whatever changes they made, these must go through you as DBA and you apply them in the productions server --------------------keeping it simple... |
|
|
|
|
|
|
Enterprise Manager The ONLY tool for DTS