How are you obtaining the resultsets? If from ADO, be sure to set the IsolationLevel of the ADODB.Connection object to ReadUncommitted. If from SQL, then you can issue a SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED command at the start of your batch. More in BOL.

HTH,

Jay