ApexSQL Comply 2014.04.1198
Find out exactly when and how an accident occurred, as well as details on who was involved using this practical and effective piece of software
Using this application you are able to identify users by their SQL or Windows login, as well as by host or application name, then create end-user reports.
The main window of ApexSQL Comply displays all of the available SQL Server instances along with the existing databases. This way, you can easily choose the databases you want to track for changes.
Additionally, you can select the operation types you are interested in, then choose the objects you want to monitor such as tables, procedures, functions and views. After that, you are able to store the captured information from multiple SQL instances in a single repository.
Since ApexSQL Comply allows you to audit all operations performed on your SQL instances, including DML and DDL changes, you are able to investigate permissions, SQL logins and role changes with ease.
What’s more, the application enables you to access the auditing reports from any device you want such as smartphone, tablet or any other external device, without having to install any additional software.
The ‘Server auditing settings’ section, available in the main window of ApexSQL Comply enables you to audit new databases, as well as exclude system objects.
You can order the reports ascending, or descending and specify the columns which will be displayed in the main window and find out which user performed changes that caused SQL Server errors.
Considering all of the above, ApexSQL Comply proves to be a steady and effective solution when it comes to auditing all SQL Server activities and tracking security changes in multiple databases.
Reviewed by Cristina Jitaru, last updated on October 18th, 2014
In a hurry? Add it to your Download Basket!
What's New in version 2014.04.1198
- Added SQL Server Failover Cluster support
Application descriptionApexSQL Comply is a straightforward and reliable application that comes in handy when you need to audit all SQL S...