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.