Every time an event with a table occurs like, insert, update or delete, a batch of SQL CODE can be executed with an entity called TRIGGER. They are managed by DBMS. Triggers can ALSO be utilized to execute a stored procedure.

Triggers available in SQL SERVER are listed below:

• DML trigger: They are called as DATA manipulation trigger. As the name suggests, they are being triggered every time, a DML command i.e. insert, update or delete occur on the table or the view.
• DDL trigger: Any changes occur in the definition of any database object, it can be captured by Data definition language trigger. Production and development-based environment can be controlled and managed by these triggers.
• Logon trigger: These triggers are handy in the case; a login event of SQL server happens. It is fired before a user session is being set up in a SQL server.

Every time an event with a table occurs like, insert, update or delete, a batch of SQL code can be executed with an entity called Trigger. They are managed by DBMS. Triggers can also be utilized to execute a stored procedure.

Triggers available in SQL server are listed below: