ApexSQL Trigger

Trigger based SQL auditing

Create self-auditing apps with triggers in SQL Server

• Track data / DML changes in SQL Server databases
•  Integrate royalty free auditing into your apps
•  Translate data into information with lookups
•  Create reports and exports from audited data
•  Customize trigger templates with a built-in IDE
•  Add additional data to audit trail with watches
•  Track schema / DDL changes in audited database
•  Audit who, what, and when for all changes

Features

Data / DML changes reporting

View details about data / DML change on each audited operation

Watches

Include any additional, relevant data to the auditing results for a particular table

Lookups

Transform values e.g. 100 to easy to understand literals e.g. Chicago

Integrated editor

Fully customize trigger templates with a dedicated IDE

Before and after auditing

Show full audit trail including data as it existed before and after a change

Visual audit management

Visualize your audit plan directly via the main interface for easy editing

Who, what, and when auditing

Find out the name of the login, host, and application used to make audited changes

Row history

View all historical modifications to a specific row

Schema change notification

Be automatically notified about changes made to the table structure

Schema / DDL changes reporting

View which database object was changed including the DDL action used to make the change

Data maintenance wizard

Maintain auditing data in the central repository

Multiple output formats

Export auditing data to plain text, Microsoft Excel, or PDF

Save as Batch file

Export audited data to batch script format

Visual themes

Customize the visual appearance with interface themes.