It also depends on several factors of what you are wanting to audit. If it is basic access on tables for INSERT, UPDATE, and DELETE then a trigger is sufficient. If for SELECT then either use Profiler or setup running traces to capture it. Another method which I use is to use procedures and no direct access whatsoever. Then I can write the procedures access to the audit table (this way I can know exactly what they ran).

Then it boils down to what type of audit. Is it change audit? Query audit? Access audit?

I do a little of each in various ways. What is your audit for and I can offer better suggestions.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)