Trigger is nothing but it will be Automatically excuted when ever event occure like Insert,Update,Delete events.
In sql server Provide two types of Trgger.
Trigger is nothing but Special kind of Stroed Procedure.
1)Instead of Trigger.
2)For/Ofter Trigger

Trigger is complied stored procedure that raises when some events (insert, update and delete) occur. The trigger can't take parameter.

More important .NET Questions & Answer

when it is in sqlsever Trigger is a special type of stored procedure which is used to insert,delete,update the statements automatically when the query is raised two types are triggers are available. 1. Instead of triggers 2. after trigger sqlserver6.0 supports upto 3 multipletriggers after this every version is supporting upto 32 multiple triggers.