dml Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

Disable and Enable triggers in SQL Server

March 5, 2015December 20, 2019 - by SQL Geek - Leave a Comment

A DML trigger is a set of SQL statements which are executed when a DML (Insert/Update/Delete) event occurs in a database. A DDL trigger is set of SQL statements executed when …

SQL Server

SQL Server: Which trigger will be triggered first?

January 6, 2012August 28, 2014 - by admin - 2 Comments.

Hi Friends, Yesterday I was working on a specific requirement of a client to create DDL trigger for a Database to log & validate certain things. While doing so I discovered …