The article was thorough and straighforward.

I find the problem with ChangeTracking and ChangeDataCapture is that there is so much hardcoding going on. That means whenever you add or delete a column, it is another area that needs to be touched. Plus the queries are pretty unwieldly and verbose.

There is a need in my group to send out an email when anything changes among multiple tables. That would be a very long query, and pretty unwieldy.

I have a lot going on with dynamic SQL to do that, but there is a performance hit.