ApexSQL Trigger (formerly ApexSQL Audit) is a perfect SQL Server auditing solution. Whether you're just beginning to learn about SQL Server and need a user-friendly tool or a seasoned user who has the confidence to create your Audit structure by scratch. ApexSQL Trigger lets you monitor updates, insert deletions, and user-specific changes by date, machine, application, and more. It also integrates the functionality straight into the application. The completely customizable and extensible structure lets you modify trigger templates directly in the built-in IDE or modify the architecture (fast reporting and audit log tables distributed etc.) ApexSQL Trigger comes with a reporting module and exports for Excel, CSV.

ApexSQL Trigger generates triggers automatically to create a Microsoft SQL Server data audit log. ApexSQL Trigger is the ability to report the data into valuable reports. It also comes with a no-cost web-based client for reporting.

• 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 the audit trail with watches
• Track schema changes in the audited database
• Audit who, what, and when for all changes

Quest Software ApexSQL Trigger Great Features:

• SQL Server 2005 and 2008 support
• Free web-based (ASP and ASP.NET) reporting client with complete source code available
• Scriptable, customizable trigger templates that allow you to modify triggers
• Profiles automatically save your field and audit selections from your last session. No more tedious reconstruction of Audit plans
• Trigger management module - delete, enable/disable view triggers in an easy-to-use interface.
• Incredibly functional template editor enables you to modify triggers or create your own using Microsoft VBScript or JScript and leveraging the full power of Microsoft Script parser and debugger.
• Template editor offers IntelliSense support for the Audit object model and includes a built-in property page.
• Data management module for deleting audit data. Functionality includes the ability to create, save and schedule Data Transformation Jobs. The DTS job manager also allows for editing and deleting existing jobs.
• The amazingly comprehensive Help file includes step-by-step articles, a full object model, examples, and architects notes.
• Accurate Reports - audit reports that allow you to print and export preformatted HTML
• Both Standard and Aggregate Reporting supported - reports can be output to Excel, text, HTML, and printer.
• An Audit data management grid allows you to filter, sort, and group Audit data for quick analysis.
• Easily manage Audit architectures by editing scripts from within the application, installing architecture, removing architecture, and running an analysis on the integrity of the current database's architecture.
• Ability to view triggers directly from the interface and even enable/disable them directly from the main form
• The Table list indicates which tables are currently audited
• Quick controls allow the selection of all tables, all fields, and all audit options or any combination of these
• View object DDL directly from the application
• Write triggers directly to the database, automatically call SQL Server Query-Analyzer and load in the script file or use the default script editor.
• Per Client licensing - audit unlimited servers