Auditing is the recording of details about many events in the database in the transaction log. Auditing provides some security
features, at the cost of some performance. When you turn on auditing for a database, you cannot stop using the transaction
log. You must turn auditing off before you turn off the transaction log. Databases with auditing on cannot be started in read-only
For the auditing option to work, set the auditing option to On, and also specify which types of information you want to audit
using the sa_enable_auditing_type system procedure. Auditing does not take place if either of the following conditions are
The auditing option is set to Off
Auditing options have been disabled
If you set the auditing option to On, and do not specify auditing options, all types of auditing information are recorded.
Alternatively, you can choose to record any combination of the following: permission checks, connection attempts, DDL statements,
PUBLIC options, and triggers using the sa_enable_auditing_type system procedure.