title: Why Use Nested Transaction In Sql Server
body: <p>What is use of nested transaction in sql server.
  As we know that there is no scope of inner transaction, if we committed inner transaction and rollback by outer transaction then outer transaction will rollback inner transaction so what is use of inner transaction</p>
  
  <p>Please explain me.</p>
  
  <p>Thanks - Girijesh Kuamr</p>