“Trigger” is a special kind of stored procedure which will be executed automatically based on the user events (Insert/Delete/Update operations)

In Sql Server 2000 there r 2 types of triggers:
1) for/after trigger
2) instead of trigger