• Thanks, you have explained some good basics for me to think about...too bad it's not offered in Standard.

    However, how do schema changes on the tblEmployee table impact the CDC's process and data when CDC is enabled for the tblEmployee table? Would you have to disable and re-enabled CDC for the table and basically recreate it? ...and in doing so, are all change data lost?

    How are transactions handled via the CSC when ROLLBACKS are executed?

    You state triggers affect performance...I agree...but WHY does the CDC perform better? Technical detail may be outside of scope of the article, but some comparison workings of the trigger vs. CDC would nice to understand why after starting with the "argument."