Using a DDL trigger to control and automate history of data changes

Summary: DDL trigger does all the magic of automatic support of historical data, all you need is to run the script against your database (once). After that you can turn history on tables on, off, or pause it. It will keep audit of all schema changes in your database and automatically generate DML triggers on […]