-
Inheritence of Set Transaction Isolation Level?
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...
Jeff Moden
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|