Detecting heavy db reads

  • Hi

    I have a customer who would like to find out is ceration of their CRM users are extracting data from the database when they should'nt. Is it possible to detect when a user has read x records from a table and set an alert for the administrator?

    TIA

    Rob

  • Not within SQL itself as there is no trigger or other mechanism for SELECT. You can however setup Profiler to monitor SELECTs in all databases and write to a table (2000) or file (7 and 2000) then manually look back at the data afterwards. The best way to handle thou is prevent by limiting access and using views and stored procedures to control data flow.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply