title: Where is the Begin/Commit mismatch in this stored procedure?
body: <p>I'm getting the following error:</p>
  
  <p><em>Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.</em></p>
  
  <p>When I try to execute this stored procedure:</p>
  
  <pre><code>create procedure [dbo].[SynchCustomerSubscriptions] (
    @subscriptions Subscriptions readonly )
  as
  
  begin transaction
  
  begin tran SynchTransaction
    begin try
      delete s
      from Subscription s (nolock)
      where s.Customer in (
        select Customer
        from @subscriptions)
      exec AddSubscriptions
        @subscriptions
    end  try
    begin catch
      rollback tran SynchTransaction
      return
    end  catch
  commit tran SynchTransaction
  </code></pre>
  
  <p>Does anyone spot the problem?</p>