O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Image

FIGURE 26.3 Using SSMS to manage ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required