O'Reilly logo

Microsoft® SQL Server 2005 Unleashed by John Kane, Tudor Trufinescu, Alex T. Silverstein, Chris Gallelli, Paul 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

Chapter 25. Creating and Managing Triggers

IN THIS CHAPTER

A trigger is a special type of stored procedure that is executed automatically based on the occurrence of a database event. In previous versions of SQL Server, the database events that fired triggers were based on data manipulations, such as insertions, updates, or deletions. Triggers in SQL Server 2005 can also fire on events that are related to the definition of database objects. The two triggering events are referred to as Data Manipulation Language (DML) and Data Definition Language (DDL) events.

Most of the benefits derived from triggers are ...

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