Enable C2 audit tracing

Enable C2 auditing tracing to configure SQL Server to record both failed and successful statements and objects access attempts. This information can help you identify and profile system activity and track possible security policy violations. C2 auditing saves a large amount of event information to the log file. If the data directory that includes the log file runs out of space, SQL Server shuts down. If your company requires the use of C2 audit tracing, you can enable C2 audit tracing.

To enable C2 Audit tracing:

1. Open the Microsoft SQL Server Management Studio, and open the properties dialog of the server object.

2. Select the Security page.

3. Select Enable C2 auditing tracing under Options.