Using DDL Triggers in SQL Server 2005 to Capture Schema Changes http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes