Schaeffrcc
Technical User
We made a change to our SQL 7.0 Server from 6.5 Compatibility to SQL 7.0 compatibility and afterwards we have been having problems with Random Locking on tables in our Application. We have since change the compatibility back to SQL 6.5 but the problems continue. (I do not know if this change back took affect?)
It seems like a Row level locking vs. Page Level locking problem but do not know how to confirm and fix.
Does anyone have any ideas on how to check if this is the problems and ways to fix it if it is the problem?
Thanks for your help,
Thomas.
It seems like a Row level locking vs. Page Level locking problem but do not know how to confirm and fix.
Does anyone have any ideas on how to check if this is the problems and ways to fix it if it is the problem?
Thanks for your help,
Thomas.