title: Converting a MySql trigger to a SQL Server 2008 R2 trigger
body: <p>So I needed to convert a MySQL database to a SQL Server 2008 R2 database. To do this I used Microsoft's new SSMA MySQL tool. Everything was converted fine except for the triggers, it kept crashing when converting them.</p>
  
  <p>First MySQL trigger:</p>
  
  <pre><code>CREATE
  DEFINER=`root`@`localhost`
  TRIGGER `dbo`.`table_A_trig`
  BEFORE INSERT ON `dbo`.`table_A`
  FOR EACH ROW
  BEGIN
     /* Logic here */ 
  END
  </code></pre>
  
  <p>Second MySQL trigger:</p>
  
  <pre><code>CREATE
  DEFINER=`root`@`localhost`
  TRIGGER `dbo`.`table_A_trig_Update`
  AFTER UPDATE ON `dbo`.`table_A`
  FOR EACH ROW
  BEGIN
    /* Logic Here */
  END
  </code></pre>
  
  <p>How should I rewrite them to be able to create them in SQL Server 2008?</p>
  
  <p>Thanks guys!</p>