Excellent stuff and very detailed. Thanks for sharing. I have done something similar in the past but never thought of using triggers, instead compared the data between old and new table quickly using Red-Gate data compare tool.

But I guess using the Change tracking feature makes it even more convenient.

Thanks!