Database Properties window: Auditing tab

This tab has the following components.

Do not collect audit information for this database Select this option to disable auditing by setting the auditing database option to Off.
Collect all audit information for this database Select this option to collect all types of auditing information for the database. This option enables auditing by setting the auditing database option to On. The transaction log can grow significantly when this option is selected.
Collect the following types of audit information for this database Select this option to specify the types of auditing information to collect. Selecting this option changes the setting of the auditing_options database option and sets the sa_enable_auditing_type system procedure to the auditing types specified below.
Select one or more of the following options:
- Successful connections Select this option to enable auditing of successful connections.
- Failed connections Select this option to enable auditing of failed connection attempts.
- DDL changes Select this option to enable auditing of DDL statements.
- Option setting changes Select this option to enable auditing of public options.
- Permission checks Select this option to enable auditing of permission checks, user checks, and SETUSER statements.
- Denied permissions Select this option to enable auditing of failed permission and user checks.
- Triggers Select this option to enable auditing after a trigger event.