Tag Archives: ddl trigger auditing

SQL Monitoring with DDL Triggers

We can create a DDL trigger to audit operations such as creating or dropping tables. DDL triggers are a very powerful tool for monitoring the actions that occur in a database. The other category of trigger is standard triggers, which can only respond to changes in data, data definition language (DDL) triggers can be used [...]