title: How do I list (or export) the code for all triggers in a database?
body: <p>I'm changing from local time to UTC-time in our database.<br>
  There are alot of triggers that copies information to history tables that currently uses <code>GETDATE()</code>.</p>
  
  <p>I would like to find every trigger that uses <code>GETDATE()</code> (instead of <code>GETUTCDATE()</code>) in the database, is there any way to do this automatic?</p>
  
  <p>I've listed them by <code>select * from sys.triggers</code> but I also need to see the actual code to be able to find the use of <code>GETDATE()</code>.</p>