ApexSQL Audit description
This software is an Audit Trail generation and reporting tool for MS SQL Server

ApexSQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft SQL Server 7 or 2000 Database auditing unmatched on the market today. ApexSQL Audit is a very useful auditing application utility.

This ApexSQL Auditing tool is both configurable and scriptable and ships with the power of Microsoft VBScript parser.

Whether you are relatively new to SQL Server© and just need an easy to use utility or you are an advanced user who is comfortable creating your own Audit architecture and modifying trigger templates - ApexSQL Audit is the perfect SQL Server© active auditing solution solution for you.

[New] ASP web reporting front end with full source code for standard and aggregate audit reports.

[New] Database transaction UNDO - this powerful new feature allows for the reversal of database operations including inserts, updates and deletes.

This powerful module is incredibly robust - it will produce a pre-undo report to explain the impact of changes and a post-undo report indicating any problems. This process even allows for a complete rollback of all undo operations pending the results of the post-undo report.

Here are some

key features of "ApexSQL Audit":

· SQL 2005 support
· FREE web based (ASP and ASP.NET) reporting client WITH FULL SOURCE CODE available on downloads page
· 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 plan.
· 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.
· Powerful 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.
· Amazingly comprehensive Help file includes step by step articles, full object model, examples and architects notes.
· Real 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 and powerful 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 interface and even enable / disable them directly from the main form.
· The Table list indicates which tables are currently audited.
· Quick controls allow selection of all tables, all field 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 default script editor.


Requirements:

· ADO MDAC 2.8 MSSQL Server v7, 2000 or 2005
· .NET 2.0 Run time
· Windows Script 5.5.


Limitations:

· 30 days trial
· nag screen