Disable and Enable triggers in SQL Server
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 …
Read MoreTag: triggers
Recursive triggers in SQL Server
In this blog we’ll look at Recursive triggers in SQL Server. Triggers are said to be recursive/nested when a trigger on a table calls another trigger on same or different table …
Read MoreDisadvantages of triggers in SQL Server
DML Triggers are stored procedures which are automatically executed when a DML operation is performed on a table/view defined in a trigger. A good use of trigger is to audit table …
Read More