[From SQLServer Performance
SQL Server 2008 introduces a new feature called SQL Server Audit. Auditing a SQL Server database involves tracking and logging events that occur on the database. This feature enables Database Administrators to implement a strategy that they can use to meet the specific risks of their SQL Server 2008 databases.
The article continues at