In SQL SVR 7 is there a way to determine which rows are being exclusivley locked?
We have a problem where a row is being inserted and unrelated rows are not getting processed by the application. I dont know if locking is the issue or not.
It could be the locking level. Look at the lock that is in effect to see what type of lock it is when occurrs. The query engine may have decided to do a page or table lock for whatever reason. You might condier adding the ROWLOCK hint to prevent higher level locking.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply