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 |
|
solnt
Starting Member
5 Posts |
 Posted - 2006-11-08 : 22:51:53
|
Hi all... Iam a newbie and i have one question want to ask experts ...  . I am current working on one App which have some user connect to database at the same time. And i want to know: how many user connect or use (read , update) to one row in a table? Could it be possible to know that??? If you have one solution to solve this problem , please let me know :) ... Could it be done by Software , T-SQL or anything ...., iam happy to know. Thanks all.  Hope help you and me... |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-08 : 23:19:45
|
| SQL Server allows simultaneous access to all users very efficiently and very safely. It locks data in various ways to prevent problems when multiple users read and write simultaneously (data is locked exclusively while being written and in a shared way when read).You should read up on locks and transactions in Books Online to find out more and see the many different statements and stored procedures that SQL Server has for managing locks and transactions. |
 |
|
|
solnt
Starting Member
5 Posts |
Posted - 2006-11-08 : 23:43:00
|
| Thanks for advise ... :) And do you have any suggest to me if i want to notify all client user when data which them current access is changed. My App is coded by VB.Net and SQL 2000Hope help you and me... |
|
|
|
solnt
Starting Member
5 Posts |
Posted - 2006-11-08 : 23:48:39
|
| Ah , I forgot something ... Because I code by VB.net and use Dataset , so i think my clients view data is offline with server . So, there will no lock on table until they update data ... Please correct me if i wrong :)Hope help you and me... |
|
|
|
|
|
|
How many user current connect to one row in table?