Audits on MS SQL Server 2008
http://www.sql-server-performance.com/articles/audit/2008_audit_intro_p1.aspx
**The Audit feature is supported only in Enterprise and Developer editions of SQL Server 2008
Introduction to Change Data Capture (CDC) in SQL Server 2008
http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-(cdc)-in-sql-server-2008/
**Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server
Auditing using DDL Trigger in SQL Server 2005
http://blogs.msdn.com/b/sqlserverfaq/archive/2008/12/16/did-you-know-auditing-using-ddl-trigger.aspx
DDL Triggers in SQL Server 2005
http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx
Introduction to DML Triggers