Actually I would like to find answers for the following situation:
Let's say I have a stored procedure (
Usp1) which at some moment calls an other stored procedure (
usp2). Each of the stored procedures is a transaction. So there are nested transactions.
- Can a deadlock occur in nested transactions while modifying the same table from 2 different sql server sessions?
- Are there any possibilities of conflicts which leads to deadllock between the inner and outer transactions of the same stored procedure in a single session?
Examples would be really appreciated.