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.
| Author |
Topic |
|
SQLSeeker
Starting Member
15 Posts |
 Posted - 2010-10-25 : 03:00:41
|
| Hello, I have a problem regarding Multiple users Simultaneous using INSERT and SELECT queries on database. The detail problem scenario is as follows:- I have a table and multiple users access the table at the same time. If one user is inserting the data , another user at the same time fires a select query to get the max no from the same table. Now at one point my VB.Net application hangs.Now is it possible to use some type of locking system to lock the data until one user finishes the insert query and does not allow the select query to fire until the process is complete. Thanks in Advance |
|
|
|
|
|
Multi User Scenario