Stored Procedure calling a view

[mander23]

I have a stored Procedure that is calling other stored procedures and other views. At the top of my main SP I have the 'set TRANSACTION Isolation level READ UNCOMMITTED' to help with locks. When I call the other SP's or views do I have to have that same statement or either 'with (nolock)' statement in them also.

 

[foxdev]

According to BOL:

Only one of the isolation level options can be set at a time, and it remains set for that connection until it is explicitly changed.

So once set, assuming no called SP changes it, it should remain so.

--------------

http://www.foxdev.com