What is a Trigger?

A Trigger is a SQL Server Procedure that executed automatically when DML event occurs on table or view.
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.