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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2008-09-19 : 02:17:42
|
| Hi All,I have a problem in concurrent data access. The same data is accessed by many users at a time, so if any one of the user has modified a row then the updated data row was not able to view by other users. So, my problem is how can i lock group of rows, so after finishing modifying the rows i have to release the rows.How to do as above..ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2008-09-19 : 02:54:54
|
| You can look into isolation levels.For your case I think repeatable read isolation level is more viable. |
 |
|
|
|
|
|
Help me in Concurrency data access