Do not want to lock the table

  • Thread starter Thread starter June
  • Start date Start date
J

June

Hi, All,

In ADO.NET, when executing sql statement, the table will be locked.
Except for using "with nolock" in the sql statement to avoid locking
the table, is there any other ways that can get the same result?

Please help. Thanks in advance.
 
Hi June,

Table locks are rarely applied. What sort of statement are you executing
that's causing a table lock?

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best practice Multiuser Program - locking 15
MS Access equiv of With(nolock) 3
Loading Data Tables in C# 1
T-SQL vs ADO.NET Transaction? 3
Lock Table 7
Can someone help explain this... 1
Implement ADO.NET Row Level Pessimistic Locking 1
How to view to be submitted query string in ADO.NET 1

Back
Top