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 ...

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.