November 14, 2006 at 5:49 pm
hi
I need to audit all access (inert, select, update delete) on a few specific tables in my sql2000 database. I need to do this as discreetly as possible so that another person with dbo rights will not immediately notice that objects are beig audited. what is the best way to do this? i looked into c2 auditing but i read that this can cause significant overhead. should i look at third party software? it is important that we audit selects as well as insert update and delete.
thanks
November 14, 2006 at 11:30 pm
You'll want to set up server side traces to do this. The auditing won't be obvious to a person in the datbase because it's at the server level. With that said, someone with sysadmin rights would have to know to look for the auditing to see this. C2 auditing basically makes use of server side traces but it audits a whole slew of things. You can probably build filters to reduce what you are auditing and be more efficient both on the performance side as well as the space utilization due to the trace files themselves.
If you aren't experienced with traces, do some playing around with Profiler in a non-production environment to figure out what you need. Profiler uses traces to get the information it displays, so that gives you a starting point.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply