SQL Server 2008 introduces a new feature called SQL Server Audit.

This story continues at http://www.databasejournal.com/news/article.php/3768521