hrvoje.piasevoli (7/2/2010)
If I need to quickly disable all triggers in the database then I use disable trigger syntax to take care of all tables and views and then append disable trigger all on database to take care of the DDL triggers (if any)
The order of execution may have to be reversed in the case of a "security" DDL trigger design patern (trigger that prevents altering db schema)
This is an excellent suggestion Hrvoje (and keen eye too :-)), thank you very much for pointing it out.
Oleg