Subject | Determining what user has a lock on a table? |
---|---|
Author | Hardee Mahoney |
Post date | 2008-11-04T22:10:20Z |
Hello,
I have an application where the database control holds an immediate lock
(pessimistic lock) on a row when that row is being edited. Is there a way,
by reading the system tables, to determine what user has a lock on that
table at that time?
Thank you in advance,
Hardee Mahoney
Washington, DC
[Non-text portions of this message have been removed]
I have an application where the database control holds an immediate lock
(pessimistic lock) on a row when that row is being edited. Is there a way,
by reading the system tables, to determine what user has a lock on that
table at that time?
Thank you in advance,
Hardee Mahoney
Washington, DC
[Non-text portions of this message have been removed]