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 |
|
Sundaresan
Starting Member
28 Posts |
 Posted - 2009-07-29 : 06:16:19
|
| Hi,Consider that there are two users A and B. Both the users access a table at the same time say the difference in Micro seconds. SQL server will determine which User to give access either A or B.My Question is how the SQL Server determines which user to give access ? Also, What is the SQL Server default minimal time to determine which User needs to get access at that instant either A or B?Sundaresan.R |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-07-29 : 06:20:52
|
| FYIThe Sql server will provide different connection for each user to access the DB. So A will be in one connection and B will be in another connection.If both try to access the same table on a same time, the table will be locked by A(first connected). once A will finish the work it will be open to B.Different type of lock can be overhead to a table depending upon the operation you can perform!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
Sundaresan
Starting Member
28 Posts |
Posted - 2009-07-29 : 06:32:21
|
| Thnx for the information. But my doubt is how SQL Server Determines A comes First and B Comes next.. Even though both hit the SQL Server at the same time ?Sundaresan.R |
|
|
|
|
|
|
SQL Server default minimal time between connection