How to Configure Audit in SQL Server 2008

Auditing gone into different level with more advanced features and robust set in SQL Server 2008 compare to sql server 2000 and 2005. It grouped into 22 classes together with 81 securable set like login, server, certificates, tables, indexes, keys, role, schema and so on. We can audit DML command with all valuable details like Insert, ...

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, ...