Interview Questions and Answers Introduction: why I started this six part series after many reader requests. The updated questions now live at a new location.
SQL SERVER – 2005 – Disable Triggers – Drop Triggers
Two ways to stop a trigger from firing in SQL Server 2005: drop it or disable it. I prefer DISABLE TRIGGER and show the syntax to disable triggers.