June 17, 2003 at 9:38 am
I am looking for a way to capture all the transactions applied to a single table in a database for audit purposes. I do not want to use triggers if at all possible. Can I get this level of granularity using Profiler trace?
June 17, 2003 at 10:04 am
NetIQ Diagnostic Manager has drill-down capabilities to check the transaction log on a specific table object.
June 17, 2003 at 10:10 am
Yes you can use a profiler trace to get the information desired. When you create a new trace click on the filters tab and scroll down to objectname or objectid and enter the appropriate. Under events tab you want more then just the default information but you don't want to add to much. I recommend adding the tsql group, performance and transactions groups. Use trial and error to see what statistics are meaningful for you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply