What is a Trigger in SQL Server?
A Trigger is a database object that is
attached to a table. In many aspects Trigger's are quite similar to a
Stored Procedure. That's why, triggers are sometimes referred to as a
'special kind of stored procedure'. The main difference between a
trigger and a stored procedure is that the former is attached to a
table and is only fired when an INSERT, UPDATE or DELETE occurs or
you can say a trigger is called automatically when a data
modification event is made against a table whereas a stored procedure
must be called explicitly.
