Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger? I know I have and on more than one occasion! This little script can be added to a SQL Agent Job and scheduled as you require to email an operator with a list of all triggers for all user databases, the table they are on and the status.