OmniAudit takes a tedious, unreliable and time-consuming task and turns it into a point-and-click tool which installs audit trail capability in any SQL Server 7.0 or 2000 database in minutes.

OmniAudit captures changes regardless of the application used to change the data: a commercial software package, an in-house application, or even the native tools provided with SQL Server such as Query Analyzer...OmniAudit will still record what data was changed and who changed it.

OmniAudit not only captures before and after values for each changed column, but also identifies:

the user making the change
the date and time they changed it
the workstation they were on
the application they were using to make the change

You decide which tables and columns to audit; OmniAudit automatically generates triggers to maintain an audit trail of all inserts, updates, and deletes made to that data.

Nonintrusive - OmniAudit is a completely server-side solution which requires no modifications to client software.

Scriptable - OmniAudit's scripting functions are completely encapsulated within an ActiveX control which can be used to script trigger creation in Transact-SQL, ASP, Javascript, VBA, and more.

Auditing is very useful in a variety of situations.

Database administrators can more easily troubleshoot and track down the origin of data corruption.

Invalid data can be more easily restored at a finer level of detail than is available by simply restoring from a backup.

Organizations with internal or regulatory requirements for following the history of data can do so easily, even if their software doesn't already handle this requirement.

Software developers can more easily develop and debug applications by tracing how data gets changed by any particular function of the software. Find unintentional side-effects faster and easier.