How to audit Database Design Modifications using a DDL Trigger

September 27, 2012 · Posted in SQL, Technology · 2 Comments 

Recently we identified the need to create a system for tracking changes made to our databases by developers and internal systems. Although the database itself is using FULL logging, which allows you to view changes made, we found that we’d like to see all modifications made over the entire history of the database in question. This prompted me to develop a table containing all changes Read more