As a management professional or an SQL DBA, if you are from an organization that maintains compliance with the industry standards, then you would like to ensure safe and secure transactions from the SQL server. You have to be on the watch for 'who', 'when' and 'which' data underwent any changes or undesired changes.

Auditing was made an integral part of the server from SQL Server 2008, which was enabled to:

With a wide variety of reports that are available out-of-the-box, SQLDBManager Plus provides boundless visibility into various SQL events and helps you adhere to compliance and security requirements.

SQLDBManager Plus tracks the audit events on your instance of SQL Server, provided you have enabled auditing in the product. It provides audit trails of user activity across login related and audit related activities as well as their server-level and database-level actions. The categorized event representation facilitates better readability. These categories are also customizable as per the users requirement.

Benefits of Audit Reports in SQLDBManager Plus:

• Track different activities such as failed logins and logouts on the server level.
• Monitor database access and activities thus improving the database performance and uptime.
• Sort & filter the audit reports to drill down to exact data you are looking for based on the date, event and type.
• Export audit data as a PDF, CSV or Email for further analysis and reporting.
• Assure your data is stored, formatted and ready for audits to ensure the security of your consumer data.
• Easy to install, use and maintain. No agent to be installed.

SQL Server Audit Reports in SQLDBManager Plus thus helps DBAs to ensure reliable protection of their business-critical databases from external and internal security threats. With instant historical reports, database administrators can take action against unauthorized activities and maintain database security.

For more information on auditing in SQLDBManager Plus, refer to our online documentation of SQL Server Audit Reports.