SQL Server Audit Trail Generation

SQL Server Audit Trail Generation

OmniAudit let's you identify any changes made to any data in your
SQL Server databases without changing your software.
An OmniAudit audit trail tells you:
• the table and field that was changed
• before and after values
• the user making the change
• the date and time they changed it
• the workstation used
• the application used

Audit trails are an important–sometimes required–part of database administration. Many systems which maintain critical information benefit from audit trails. Often government regulations such as Sarbanes-Oxley, 21 CFR Part 11, and HIPAA require audit trails on electronic records.

Audit trails also are tremendously useful for internal quality assurance. Any organization which develops database software–whether strictly for in-house use or as commerical products–can greatly streamline debugging and testing with an audit trail showing the net effect of how a software function changes the database. Nothing beats an audit trail for highlighting unintended side-effects either.

How Does OmniAudit Help You Build Audit Trails?
  • Auditing is automatic and transparent No need to change any existing software
  • Audits occur regardless of application Whether a commerical software package, an in-house application, even Microsoft tools such as Enterprise Manager, Query Analyzer, or Microsoft Access. OmniAudit sees all.
  • You choose what to audit Audit every field in your database, just a few fields in a single table, or anything in between.
  • Flexible Change your auditing selections at any time and with one click of a button, OmniAudit automatically updates all affected tables without impacting your existing audit trail data.
Use OmniAudit as Part of Your Compliance Programs
OmniAudit Quick Facts
Supported SQL Servers:
SQL Server 7.0, 2000 & 2005;
including MSDE and Express editions
Operating Systems:
Windows NT / 2000 / XP / 2003 / Vista
Price (USD):
$479.00 Single-User
$1999.00 Site License