title: Nested transactions in Sql Server
body: <p>Imagine the following scenario:</p>
  
  <p>I am using SQL Server 2005. I have a transaction that is calling, among other SQL statements, a stored procedure that also has a transaction inside. The outer transaction sometimes fails and it is rolled back after the stored procedure is called and committed successfully.</p>
  
  <p>My question is, does the stored procedure's transaction rollback too?</p>