OmniAudit allows you to track changes to data in any table for MSSQL 7/2000.

OmniAudit not only captures before and after values for each changed column, but also identifies: the user, date and time, the workstation used, and the application used 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. OmniAudit is a completely server-side solution which requires no modifications to any client software.

Data auditing can be valuable to an IT organization in a number of ways:

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

* 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.

* Quality Assurance functions can validate data altering features more quickly and with greater accuracy.