SQL Server 2008 has some great new features. One of them is the new auditing capability. Now we can audit at the server, database and table level according to specifications provided by the DBA.

Reported events. To start auditing, first ensure that your login is assigned SQL Server sysadmin rights. Depending on what you want audited, you can either customize SQL Trace or enable C2 auditing.