[
From Builder.com]
A trigger is a database object similar to a stored procedure that executes in response to certain actions that occur in your database environment. SQL Server 2005 is packaged with three flavors of trigger objects: AFTER, data definition language (DDL), and INSTEAD-OF.
The article continues at
http://builder.com.com/5100-6388_14-6113179.html?part=rss&subj=bldr