What is a Trigger?

A Trigger is a SQL Server Procedure that executed automatically when an event occurs on database server.
Triggers are stored in SQL Server Database. Triggers are used to maintain the referential integrity of the data. Trigger’s logic can be viewed and dropped similar to stored procedure.