This article covers different types of triggers supported by Microsoft SQL Server 2005 with basic ideas about them with an example. At last describes the step-by-step approach to create a CLR trigger (a DML type).
A trigger is a Database object just like a stored procedure, or we can say it is a special kind of Stored procedure which fires after (/before) a specified language event executes. More specifically the object which is attached to a Table or View or Database schemas for tracking the operations on them. The main difference between a trigger and a stored procedure is that the former is attached to a table or view and is fired only when an INSERT, UPDATE, and/or DELETE occurs, while a stored procedure executes at any time when it is called.