Can we have trigger on DDL statements?
Rahul Chavan
Yes
yes we can use
Yes we can have triggers for DDL statements Create TRIGGER [SchemaChange_DDL]ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE As Begin --Your code End
Yes we can have triggers on both DML and DDL statements. These trigger are called as DDL triggers.