We have that set at 3.

>What is SET TABLEVALIDATE setting?
>
>>After some more work, we're having a different problem but on a related note.
>>
>>We've implemented an audit trail stored procedure that gets called on every trigger for each table. There is a specific multi-user test case that we run which can predictably produce a "File is in use by another user" message on one of the two workstations. The error happens when one workstation has "Attempting to Lock... press ESC to cancel" in the status area and ESC is pressed.
>>
>>For starters, we have SET REPROCESS set to 60 seconds. According to the documentation, the allowing of hitting ESC to cancel should not be showing up in the first place, but that's a different question. We're trying to anticipate user behavior.
>>
>>When the error pops up in my IDE, it's not suspendable but I can maximize the debugger window and see that the error has occurred on a line in the stored proc where we're attempting to open the audit trail table in shared mode:
>>

USE AuditTrail IN 0 SHARED

>>
>>My guess is that workstation B has a table header lock on this table, but I don't know for sure. The first question here is why I'm getting an error if the attempt is made to open a file non-exclusively. The next question would be what is the best way to trap this error to allow for a graceful exit.
>>
>>I tried wrapping the above statement in an ON ERROR routine with a RETRY and that locked both workstations indefinitely.
>>
>>HELP! :)