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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-25 : 22:08:55
|
| xiaosha writes "hi. i have a desktop application that is installed in multiple PCs. When client A retrieves a row from a table, is there a way to lock the table to prevent other clients from retrieving the values in the row until client A update the rows?i have tried using disconnected recordset, playing with the lock type and cursor type, but i realised they only lock the database before any update is done. but for my scenario, i need to lock the database the moment "SELECT .." is done. is there any workaround?tks :)" |
|
|
|
|
|
Lock database