title: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
body: <p>From the below code,we are getting exception at raiseerror - The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.</p>
  
  <pre><code>IF @insertOrUdate = 'D'
  BEGIN
  
      -- DescType depends on CorrectionType and is also a protected sync table, 
      --  it needs to be cleared out before we can remove this type
      IF EXISTS(
          SELECT TOP 1 * 
          FROM [dbo].[DescType]
          WHERE 
              [CorrectionTypeId] = @correctionTypeId
  
      )
      BEGIN
      PRINT 'raise error'
          RAISERROR('Dependent Desc Role Type Rollups must be removed prior to removing a type that they depend on', 16, 1)
  
          PRINT 'after raise error'
      END
  
      -- Delete protected Sync record
      DELETE FROM [dbo].[CorrectionType] WHERE [CorrectionTypeId] = @correctionTypeId;
  
  END;
  </code></pre>