• Good Article David,

    do you think you can change the method to use CDC in SQL2008 instead of triggers? We all know why we do not want to use triggers.

    The CDC do not give you the SQL that needs to be run to roll forward and roll backward. IF you make the article for SQL2008 this will still has its value.