Microsoft® SQL Server 2012 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 26.3 shows the Object Explorer tree and the nodes related to DDL triggers at both the server and database levels. The tr_TableAudit trigger you created earlier in this chapter is shown under the Database Triggers node. Figure 26.3 shows the options available when you right-click a database trigger in the Object Explorer tree.

FIGURE 26.3 Using SSMS to manage ...