instead of setting the isolation level for the procedure try locking hints at the statement level. We use a lot of nolock or readuncommitted hints in are application. You might...