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