title: Cannot roll back subtransaction. No transaction or savepoint of that name was found
body: <p>i have a loop while in sql which do something as it</p>
  
  <pre><code>    begin tran one
  
      do some inserts in others tables
  
        --start loop
       begin tran two
        --do something
        begin try
  --if something fail then a trigger does rollback and this return a error (and this goes to catch), then don't i need do the rollbak in catch? this could not be dissable because this is working on production
        --something finished ok 
        commit tran two
        end try
        begin catch
       rollback tran two
        end catch
  
      --finished loop
      commit
  
  
  ----------
  </code></pre>
  
  <p>i got this error</p>
  
  <blockquote>
    <p>Uncommittable transaction is detected at the end of the batch. The
    transaction is rolled back.</p>
  </blockquote>
  
  <pre><code>begin tran one
  begin tran two
  
  rollback tran two
  </code></pre>
  
  <p>doing this code i get this:</p>
  
  <blockquote>
    <p><strong>Cannot roll back two. No transaction or savepoint of that name was found.</strong></p>
  </blockquote>
  
  <p>I only want the subquery to rollback the second loop and continue with others records.</p>