I have SQL 2014 Enterprise and have configured Change Data Capture (CDC). I have UserId columns on all of my tables. So CDC does a great job seeing who inserted and updated a row but if someone deletes a row I cant see who deleted the row (it has the previous UserId in the row). I know Oracle has this feature included in their CDC package. I have SQL 2014 Enterprise and have configured