Instead of setting the transaction level in SQL for seeing uncommitted transactions you can now use the nolock hint as in the sql statement below:select * from PROJTABLE (nolock) order by RECID descif you have many tables in the query:-- Get the funding limit tracking records by project IDselect T8.AccountingDistribution, T1.ProjectAccountingDistribution, T1.RecId as ProjFundingLimitTrackingRecId,...