SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers | Journey to SQL Authority with Pinal Dave

Just a day ago, I received question in email regarding my article SQL SERVER - 2005 Disable Triggers - Drop Triggers. Question : How to disable all the triggers for database? Additionally, how to disable all the triggers for all servers? Answer: Disable all the triggers for a single database: USE AdventureWorks; GO DISABLE TRIGGER… Continue Reading...

Source: SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers | Journey to SQL Authority with Pinal Dave