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 |
|
mmarino
Starting Member
2 Posts |
 Posted - 2002-02-06 : 13:11:37
|
| If a record has been locked (just a row lock), is there a way to know? For example, I lock row 50 for update in one connection. Then I try to access row 50 from another connection, is there any way to get a message that the record is locked? |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-06 : 13:20:30
|
| If you SET LOCK_TIMEOUT 0 on the second connection, it will error out instead of waiting for a lock.Edited by - izaltsman on 02/06/2002 13:21:23 |
 |
|
|
|
|
|
checking for locks