Greetings,

I have a "main" stored procedure that executes other stored procedures and it looks something like this...

Set Transaction Isolation Level READ UNCOMMITTED
.
.
.
EXEC (storedproc1)
EXEC (storedproc2)
EXEC (storedproc3)
.
.
.
Return

My question is: Will the EXEC'd stored procedures run as if the Transaction Isolation Level had been explicitly set within those stored procedures? In other words, do the EXEC'd stored procedures inherit the Transaction Isolation Level of the "main" stored procedure?

Thank you for your time...