SQL Server Performance Forum – Threads Archive
Disabling DTS For Certain users
How can i disable certain users from running DTS /import and export without affecting their noramal read operations in sql query analyserCheckhttp://vyaskn.tripod.com/sql_server_dts_best_practices.htm DTS best practices and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;282463 fyi, I think it is not possible to restrict on certain areas of DTS. I believe SSIS is good at this feature. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>