SQL Server 2005 – How to enable C2 Auditing

C2 Audit Mode can be configured by sp_configure or sql server management studio. Using this option you can configure sql server to record both failed and successful attempts to access sql server database and objects.  To track issues related to security policy violation and system changes C2 audit mode can be used. In real scenario, ...