SQL Server Audit Trail Generation
features
Point-And-Click Setup; Be Auditing in Minutes

Check off the tables and fields you want to audit, select a few options, click a button and OmniAudit creates the audit trail tables and triggers for you.

OmniAudit: Select tables and fields to audit    OmniAudit: Setup audit log tables    OmniAudit: Build audit triggers
(click image for larger version)
Analyze Audit Trail Data Without Knowing SQL

The included OmniAudit Log Viewer tool lets you easily zero in on audit data by table, field, user, date, workstation, or application. Save the results to an Excel worksheet, HTML or XML document, or plain text.

Accessible Audit Trail Data

Audit trail data is stored in SQL Server tables and can be accessed using normal SQL Server query tools (provided you have given the user security access).

Nonintrusive

Auditing is performed on the server and requires no modifications to client software.

Capture Reference Data, Not Just Changed Data

When an audited value changes, you can have additional values from that row added to the audit trail...whether they changed or not. For example, you can have EmployeeNum written in the audit trail whenever ANY data in the Employee row changes. [more info]

Automatically Purge Audit Trail Data

Depending on your auditing requirements, you may only be interested in retaining recent audit history. You can configure OmniAudit to automatically purge audit trail history after a given number of days, weeks, or months have passed.

OmniAudit: Purging audit log data
(click image for larger version)