unless i'm missing something it appears "change data capture" would do what i need. We're going to be building this in sql server 2016