How to create DDL Triggers in sql server 2008 R2

  DDL (Data Definition Language) triggers are same as regular trigger that fire automatically whenever any event occurs. DML triggers fire in response to UPDATE, INSERT and DELETE whereas DDL triggers fire in response of CREATE, ALTER and DROP. Data changes so frequently in the real world that keeping track of each and every change ...