Auto-Audit

Implementing an Audit Trail to track database changes is a common need but bullet-proof solutions are rare. Even if you have code in your app. that writes to an Audit Log there`s no way to Capture data coming in from another front end or direct input to the database via Query Analyzer. Anything other than a server side solution can`t be guaranteed get all the data but who wants to write all the procs or triggers to implement it? Auto-Audit generates server side triggers automatically that capture audit data from every update, insert and delete that occurs on every field that you choose to track. If your database changes, simple drop your audit triggers and re-run Auto-Audit to Layer on bulletproof audit trail functionality every time. You select which tables and fields to track, from only a few to every field in the database.Features Transactional based audit table minimizes size of audit log Powerful reporting tool that allows output to screen, text file or MS Excel Ships with 2 reporting procedures to allow users to build their own Audit log Extract applications. Users can save an Audit profile for each database and retrieve it the next time they use the application or rebuild a profile from scratch by interrogating the database if it has changed. Preserves the value of @@Identity, normally overwritten when triggers insert data into Audit log. Support for Aggregate reporting - i.e. how many records updated by user by day, how many operations by user x by table over the last month, etc. !!!New - On-Line reporting. Real time, web based SQL Audit trail tracking. Visit our site for an on line demo.