What is a Trigger?

A trigger is a SQL procedure or SQL CLR Code that initiates an action when an event (like INSERT, DELETE or UPDATE) occurs on an object.Based on events which take place in your database, you can have SQL Server “listen” for just the ones that should signal when it’s time for actions to run automatically.