Question - Can we disable a trigger? if yes HOW?
Answer -
YES, we can disable a single trigger on the database by using “DISABLE TRIGGER triggerName ON <>”
we also have an option to disable all the triggers by using, “DISABLE Trigger ALL ON ALL SERVER”