title: SQL Server - Nested transactions in a stored procedure
body: <p>Lets say this is the situation: </p>
  
  <pre><code>  [Stored Proc 1]
    BEGIN
       BEGIN TRANSACTION
         ...
              exec sp 2   
       COMMIT
    END
  </code></pre>
  
  <p>Now, if SP 2 - rolls back for whatever reason, does SP 1 - commit or rollback or throw exception? </p>
  
  <p>Thanks.</p>