SQL Server Performance Forum – Threads Archive
Audit for altering of records in user tablesHi, I am using sp_trace_* extended stored procedures to perform audit trace.
The requirement to logged activities than selecting or altering records in user tables in non-system databases.
Is there a filter or customization of events in profiler stored procedures that can achieve this?
How about using a third party tool such as DBAudit Expert. DBAudti Expert create triggers on your tables to capture the activities on them http://www.sql-server-performance.com/da_dbaudit_spotlight.asp —————————————-
Cast your vote
Thanks for that suggestion. I am considering to archieve it using features out of the box from MSSQL. So, does that means it is impossible to log SELECT, INSERT, UPDATE, DELETE, EXECUTE just on user tables/procedures using profiler.