The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature.

With Microsoft SQL Server 2008, all this can be done with ease. The software comes with an in-built feature known as change data capture (CDC) that captures DDL and DML changes in a database table ...