Problem with nested transaction
I am facing a problem with transactions. I can't explain the whole Scenario but i can explain why i am logical confused. I want to know if we have a transaction in asp.net attach to a sqlcommand. The command is calling several sql procedures one after another. In these procedures we are also using transactions. I want to know how these transactions behave. Means what happen if the transactions in procedure rollback, or commit to the asp.net trasaction.
Will it also be affected or not.
Suppose sqlcommand is calling three procedure proc1, proc2 and proc3 one by one.We have attached a transction to sqlcommand. After successfully calling the proc1, sqlcommand moves to proc2.
In proc2, we are using trasctions and in a perticular condtion we rollback or commit inside proc2. Will it rollback the work done in proc1 also.
Please help me asap.
Thanks in advance