Audit trails allow you to
identify who changed what data, and they are a valuable but
difficult feature for any SQL Server database design.
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.