select events 1

[mushin]

Has anyone ever heard of an "ON SELECT" event or trigger ?
If so, perhaps an example or reference point.

I am trying to trap rows accessed from a view table for audit purposes...........

TIA [sig][/sig]

 

[foxdev]

About the closest you can come to what you want is using the SQL Server Profiler (see the BOL topic "events, object&quot, but it may not give you everything you want.

As discussed in other threads on this topic, the better way is to revoke select permissions on the desired table, and only allow queries via a stored procedure. The SP can then log the operations as part of its nature. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[TomSark]

Excellent question and Robert is right. The only way to audit this is: in profiler, through a proc, or though a trigger.

You can filter out enough stuff in profiler to capture the SELECTs. You can store the output of this trace in another table for future querying. If you need more info, you can write an INSERT trigger on your profiler output table to gather even more info...

Thanks,

Tom