Auditing in SQL Server 2008
December 15, 2009[From SQL Server Performance]
Auditing is the monitoring and recording all user actions on a database. You can base auditing on individual actions, such as database backup, change of user logins, insert etc. or on combination of factors.
Though auditing has become a popular buzzword, many DBAs and developers still do not appreciate the requirement for auditing
The article continues at http://www.sql-server-performance.com/articles/audit/2008_audit_intro_p1.aspx