ApexSQL Trigger

Trigger based SQL auditing

Seamlessly integrate trigger based audit trails and reporting into your client applications

 

?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

System requirements

Hardware requirements

 Dual Core 2.0 GHz CPU

 4 GB memory

 100 MB disk space 

SQL Server

 Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005

 Azure SQL Database

OS

Windows Vista/Server 2008 and above

Required 

Microsoft .NET Framework 4.5 

Testimonials

ApexSQL Trigger has saved us hours of programming. It produces reliable code, and addresses important auditing requirements of our point of sale applications

Gary Low

President

Remington Stevens Research

ApexSQL Trigger Viewer

?Free win client reporting interface

?Allow end users to query and audit on reporting data

?Group, sort, and filter audited data

?Export to Excel and CSV

Save a bundle

ApexSQL Trigger is included in ApexSQL Developer

?14 ApexSQL developer tools

?Priority support

?1 year support and upgrades

?New products added

?Combined 75% savings