Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Tables locking when using ADO

Author  Topic  Anna Starting Member 20 Posts Posted - 2001-07-20 : 05:09:24 We're encountering a problem with tables locking up when running sps from VB using ADO. Even though Lock Optimistic is being specified, the whole table seems to lock up until the query is complete and no-one else can query that table. Obviously, this is a problem! We did wonder if the problem could be associated with us using the Developer version of SQL Server 2000. If anyone can shed any light on this, it would be much appreciated! Anna Anna