title: Try catch in trigger not suppressing error
body: <p>I have a trigger and I want to surround the dml statements in the trigger by a try catch block so that any exception that occur in the trigger does not throw any exceptions outside the trigger. But the error is not suppressed.</p>
  
  <p>My trigger is :</p>
  
  <pre><code>ALTER TRIGGER [dbo].[Deal.OnInsertUpdateAddDealAuditDetails]
  ON [dbo].[Deal]
  AFTER UPDATE, INSERT, DELETE
  AS 
  BEGIN
      BEGIN TRY
          --SOME DML STATEMENTS
          select 1/0
      END TRY
      BEGIN CATCH
          SELECT 
              ERROR_NUMBER() AS ErrorNumber,
              ERROR_MESSAGE() AS ErrorMessage;
      END CATCH
  END
  </code></pre>
  
  <p>The error output is:</p>
  
  <blockquote>
    <p>Msg 3616, Level 16, State 1, Line 1<br>
    An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back. </p>
  </blockquote>