riggers and stored procedures both use more system resources than constraints, and so should be used only when more basic validation methods cannot get the job done. Think of a trigger as the SQL Server equivalent of an AfterUpdate or Change event. Triggers fire when an update, insert, or delete happens on a table. Triggers consist of Transact-SQL and can perform any number of tasks in response to a data change.