See article http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ddl-TRIGGER-workbench/ which describes 
SQL Server 2005 DDL Triggers.

I have implemented these with some amendments:- 




CREATE TABLE [dbo].[DDLChangeLog]...   more »