New answers tagged

1

The only disadvantage is that it will produce more data than are necessary to identify the affected row, but since that is what you want, it is not a disadvantage to you.


1

Instead of using triggers on the CDC tables, you should use the built-in CDC functions for returning the changes recorded by CDC. If you only need the latest value for each row, use cdc.fn_cdc_get_net_changes but if you need all intermediate changes as well, use cdc.fn_cdc_get_all_changes. These functions are created for each table (or 'capture instance') ...


Top 50 recent answers are included