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

What’s New in Creating and Managing Triggers

The features and methods available for creating and managing triggers are essentially the same in SQL Server 2012 as they were in SQL Server 2005. The upside to this is that you can take the knowledge and skills that you have with SQL Server 2005 and apply them directly to SQL Server 2012.

One area that has had some minor changes in SQL Server 2012 relates to events captured by DDL triggers. In SQL Server 2012, several new events fire DDL triggers and event notification. These new events are centered on new features that were added to SQL Server 2012, including AlwaysOn Availability Groups. Refer to the “Using DDL Triggers” section later in this chapter for a complete list of DDL statements and system ...

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