In this article, Brian Myers demonstrates how to build a database structure auditing solution with DDL triggers. This allows DBAs and developers to keep track of all changes to the structure of a database including when a table is added or when a column is changed, and is most useful during development and testing. Instead of developers or DBAs keeping a log of database changes, DDL triggers, new to SQL Server 2005, can be used to automatically collect the necessary information. This article includes SQL Server 2005 scripts to create a database to hold the audit information as well as scripts to create the DDL triggers. After reading this article you will be able to deploy a database structure auditing solution within SQL Server 2005.