Microsoft® SQL Server 2008 R2 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 30.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 30.3 shows the options available when you right-click a database trigger in the Object Explorer tree.

Figure 30.3 Using SSMS to manage DDL triggers.

The DDL triggers scoped at the server level are found in the Triggers node under the ...