Triggers are used in Microsoft SQL Server for various purpose. These are used when :
- Creation of audit log of database activity.
- For applying business rules.
- For applying calculation on data from tables which is not stored in them.
- To enforce referential integrity.
- When alter data in a third party application needed.
- To execute SQL statements as a result of an event or condition automatically.