title: How to get the list of active triggers on a database?
body: <p>My application is based on a sql server db.</p>
  
  <p>All customers has the same db except for customizations.</p>
  
  <p>Some customizations include: new tables, modified tables, custom views, custom triggers...</p>
  
  <p>When I run the software update some scripts are executed. Now I manually disable triggers and reenable after the scripts are done.</p>
  
  <p>Anyway I would like automatically to disable all the triggers (that are enabled, may be some of them could be already disabled) and then reenable them at the end.</p>
  
  <p>Not to reinvent the whell, how to do that?</p>
  
  <p><strong>How to get only the active triggers on the current db?</strong></p>
  
  <p>Once I got this I can programmatically create and run the</p>
  
  <pre><code>DISABLE TRIGGER triggername ON TABLENAME
  
  ENABLE TRIGGER triggername ON TABLENAME
  </code></pre>