I am very interested in the new Change Data Capture feature coming out for 2008, and how it works (haven't had a chance to dl the ctp yet). First, what are the dml features (is it reading the log?) and what are the sp's for them? Second, I would like to know, would it be possible to manually create these sp's on a 2005 environment? THX!
Best to read on SQL 2008 BOL and http://sqlserver-qa.net/blogs/sql2008/archive/tags/data capture/default.aspx too.