I'm also currently trying to find a way to identify recently changed data on a subscriber. I'm considering CT and CDC and would like to know what you implemented and your thoughts on the results.

Right now, I don't see how we can reinitialise using CT and not lose where we were up to before the reinit.

Using "DELETE" over "DROP " on the precmd of the article solves the thing with CDC, but I'd have to scan everything using this technique and CT.

Regards