Deadlocks

Andrew · Post by **Andrew** » Fri 13 Jan 2006 15:33

Hi,
I have a problem with using ctDefaultResultSet cursor type in TMSQuery. FetchAll - false. Usually I have about 100 opened connections on the SQL Server. And time from time tables' deadlocks appear on the Server. Other users can't work with the program because of an error "Timeout expired". Is there a solution for this problem? Thanks in advance.

Ikar · Post by **Ikar** » Mon 16 Jan 2006 13:33

No, this is MS SQL limitation. You can read more about it in SDAC help.