Previous Topic: Define an Asymmetric Key in SQL ServerNext Topic: Define an SQL Server Server Audit


SQL Server Audit Specifications

Server Audit introduces native auditing capabilities to the SQL Server engine. The Audit object defines a single instance of server or database-level actions to monitor. The audit is at the SQL Server instance level. Multiple audits can exist for a SQL Server instance. The Audit File object defines the specifications for the physical file used to contain the audit data.

The Database Audit Specification object is also part of SQL Server Audit. A DBA can create one database audit specification per SQL Server database per audit. The database audit specification collects database level audit actions. You can also add either audit action groups or audit events to a database audit specification.