Difference between DML Triggers and DDL Triggers in MS SQL Server
A trigger is an event based stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. DDL trigger is executed
Read more