Nested Transaction in nested stored procedures
<p>Actually, I got a little confused about using nested transaction in stored procedures. 
I need to call the two/three procedures with in one main procedure.</p>

<p>Eg:</p>

<pre><code>Begin try

Begin Tran -- 1st level transcation

Procedure 1 --will be executed

Procedure 2 --will be executed

End tran -- 1st level transcation
End try
Begin Catch
Rollback tran
End Catch


PROCEDURE 1:

BEGIN TRAN TRAN1
///scripts
COMMIT TRAN TRAN1


PROCEDURE 2:

BEGIN TRAN TRAN2
///scripts
COMMIT TRAN TRAN2
</code></pre>

<p>Am I doing it in a right way?</p>