Microsoft SQL Server 2008 - Change Data Capture – Part I 
(Muthusamy Anantha Kumar) One of the new features in Microsoft SQL Server 2008 is the ability to track changes on a table. You can enable change tracking on a table using the Change Data Capture feature.
Read Article >>