SQL Server 2000
By understanding how to create, modify, and maintain triggers, you can use triggers to:
- Cascade changes through related tables in the database.
- Disallow or roll back changes that violate referential integrity, thereby canceling the attempted data modification transaction.
- Enforce restrictions that are more complex than those defined with CHECK constraints.
- Find the difference between the state of a table before and after a data modification and take action(s) based on that difference.