Capture DDL Changes using Change Data Capture with SQL Server 2008
July 29, 2008[From SQL Server Performance]
SQL Server 2008 introduces a new feature called Change Data Capture (CDC). CDC Captures DDL and DML activity on a SQL Server table, and places the changes in a separate SQL Server relational table. In this article we will see how CDC can help DBA's to track the DML changes for SQL Server tables. The CDC feature is by default disabled at the database level. A member of the sysadmin server role must enable a database for CDC. Once the database is enabled for CDC any member of the dbo fixed database role can enable tables within the database for Change Data Capture.
The article continues at http://sql-server-performance.com/articles/dba/Capture_DDL_Changes_Using_Change_Data_Capture_p1.aspx