I am testing a client sever application and need to verify the operation of locking handling.
When I use Query Analyzer to obtain a lock, and then use the thick client to attempt a transaction that requires that lock, I can see that an error 1222 is raised (by using SQL profiler) after the appropriate amount of time, but the client does not attempt to retry!
The application vendor says that when they run an identical test, the client retries three times before giving up.
I have searched various sites but can not see any general problems reported that might cause this behavior, but I may not have looked hard enough!
Is there any setting on the database side that could cause such differences in client behavior?