Adrian Klaver wrote :
>
> Seems you are looking for Serializable Isolation Level: > True , that would solve the race condition, but it is too drastic. We need to run with Read Committed. I am looking for a solution which does not alter the application or overall behaviour, but just addresses detecting which predicates to apply in some way. Cheers, John |