Microsoft SQL Server 2014 Unleashed

Managing DDL Triggers

The administration of DDL triggers is similar to the administration of DML triggers, but DDL triggers are located in a different part of the Object Explorer tree. The reason is that DDL triggers are scoped at the server or database level, not at the table level. Figure 27.3 shows the Object Explorer tree and the nodes related to DDL triggers at the database level. The tr_TableAudit trigger you created earlier in this chapter is shown under the Database Triggers node. Figure 27.3 shows the options available when you right-click a database trigger in the Object Explorer tree.

FIGURE 27.3 Using SSMS to manage DDL triggers. ...