SQL Server Triggers Types
DML Trigger
AFTER Trigger
INSEAD OF Trigger (a kind of Before Trigger)
DDL Trigger
Log on Trigger
CLR Trigger (DDL/DML)
Specific Considerations
AFTER VS INSTEAD OF Trigger
No Before Trigger in SQL Server
DML Trigger Uses Guidelines