ApexSQL Audit allows you to seamlessly integrate data auditing and reporting into your client applications, it can help you audit and undo SQL database changes and easily determine who and when changed the data. ApexSQL Audit is compatible with all SQL Server 2014, 2012, 2008 R2, 2008, 2005 and databases, it enables you to schedule unattended report generation via the command line interface, quickly identify unauthorized or malicious change, create end-user reports to document the changes in your environments, isolate specific operations by user, date, object, change type and more. With ApexSQL Audit you can translate audit data to information with watches and lookups, find out exactly when and how an accident occurred, details on who was involved, as well as monitor table definition changes.
Features:
- Support for Windows SQL Azure Databases
- Full support for SQL Server 2014
- Store auditing data in a central, easy to manage repository
- Include any additional, relevant data to the auditing results
- Transform ID values to easy to understand literal values
- Export auditing data to plain text, Microsoft Excel, or PDF
- View all historical modifications to a specific row
- Process auditing data during off-peak hours via the command line interface, minimizing the overhead on your server
- Save your options to a project to quickly access audit settings
- View all historical modifications to a specific row
- Process auditing data during off-peak hours via the command line interface, minimizing the overhead on your server
- Save your options to a project to quickly access audit settings
v2014.0 [Jul 29, 2014]
Enhancements:
- Filtering by application and login.
- CLI commands for archiving, verifying integrity, starting and stopping an auditing instance.
Fixes:
- The "The server cannot handle directory requests" error is encountered when entering domain credentials and validation of the service account throws an exception preventing the installation to complete.
- Upgrading of an auditing instance doesn't work.
- The application cannot audit the following events: Alter role, Alter server role, Audit login and Audit login failed.
- Selecting the data source in the reports option tab doesn't work.
- Legacy reports don't work due to an incorrect version of "Microsoft.ReportViewer.ProcessingObjectModel.dll".
- The application counts every SQL Server cluster node as a separate license instead as a single clustered instance license for SQL Server cluster.
- The events cannot be collected from the clustered server if a cluster node have "-" in its name.
Changes:
- Product name changed to ApexSQL Audit.
Feature-rich relational database known for its high performance and excellent concurrency
