Re: Audit trail for web application

From: Steve Troxell (steve_troxell_at_hotmail-nospamforme.com)
Date: 06/22/05


Date: Tue, 21 Jun 2005 21:30:08 -0400

Parag wrote:

> I am trying one approach with the help of triggers. But the problem with
> this approach is that I am not able to store all the information need to
> reproduce the same output if I try to generate report for the particular
> session.
>

What information were you not able to get with triggers?

OmniAudit will build audit triggers for every table in your database in
a couple of minutes. If your schema changes, press one button and audit
triggers are synchronized again.

http://www.krell-software.com/omniaudit

Contact me at info@krell-software.com about an add-on which lets you
track application users independently when a single SQL Server login is
shared, or for any other questions about meeting your needs.

Steve Troxell
http://www.krell-software.com