title: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2
body: <p>I writed this trigger: </p>
  
  <pre><code>ALTER TRIGGER [dbo].[trg_abort_insert]
  ON [dbo].[F_DOCCURRENTPIECE]
  AFTER UPDATE
  AS
  BEGIN
  SET NOCOUNT ON
  SET XACT_ABORT ON
  BEGIN TRY
      BEGIN TRAN
  
  IF EXISTS (SELECT * 
             FROM Inserted i  
             INNER JOIN Deleted d ON i.CBMARQ= d.CBMARQ
             WHERE i.DC_Piece &lt;&gt; d.DC_Piece 
               AND i.DC_Domaine = 0
  
              AND i.DC_IdCol = 6)
  COMMIT TRAN
  END TRY
  BEGIN CATCH  
  SELECT ERROR_MESSAGE()
  IF @@TRANCOUNT&gt;0
          ROLLBACK
  END CATCH;
  END
  </code></pre>
  
  <p>I'am having this error: 
  Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2</p>
  
  <p>Pleaze help me</p>