Enabling Auditing

Use sp_configure to enable auditing.

Prerequisites
You must have SSO permission to enable auditing.
Task
To enable auditing, enter:
sp_configure 'auditing', 1
See the Security Administration Guide.