SQL Server LockMode

eduardomendes · Post by **eduardomendes** » Mon 15 Mar 2010 20:38

when I try to open a table in SQL Server that is being edited by another User, the following error occurs: "Lock request timeout period exceeded".

UniTable Configuration:
LockMode = lmPessimistic
RefreshOptions = [roBeforeEdit]

In PostgreSQL, it's not happen.

I can open the table, but I can't edit the same record. It's right, but in SQL Server, an error occurs when I try to open the table.

Whats happening?

Challenger · Post by **Challenger** » Wed 17 Mar 2010 13:41

This may happen if your table does not have Primary Key.