• refer these links

    http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx

    http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)