I have a stored procedure which builds a report. It calls several other stored procedures to build the report. These procs have READ UNCOMMITTED in them, however the parent proc does not have any explicit isolation set, so the default is READ COMMITTED. We are still seeing significant blocking from the report as a whole. Does the report as a whole operate with isolation level READ COMMITTED since the parent proc has nothing set?