EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources]

Trigger Utilization

Triggers are like stored procedures in that they contain a set of T-SQL statements saved for future execution. The big difference is that, unlike stored procedures, triggers are executed automatically based on data activity in a table. A trigger may fire based on UPDATE, INSERT, or DELETE operations.Chapter 6.