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 |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2002-03-01 : 04:51:34
|
| Hi everybody, Is it possible to check for the presence of a lock on a record/row in a table, from a stored procedure ?Utpal |
|
|
sica
Posting Yak Master
143 Posts |
Posted - 2002-03-01 : 06:21:04
|
| Check BOL for sp_lock or syslockinfo... |
 |
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-03-03 : 00:22:12
|
| Thanks a lot ! |
|
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-03-04 : 06:01:48
|
| Could you give an example as to how to determine whether a record/row in a table is locked using syslockinfo / sp_lock ?E.g. I have a table UOM_Master in which I want to determine whether the record/row having uom = 'kgs' is locked.How could I do that ? |
|
|
|
|
|
|
Check for record lock