>I posted this question a week or two ago and got no answer (well... none that I liked anyway :-))
>
>Is there a way I can tell which record(s) in a table are locked without scanning the table and checking for locks on each individual record?
>Even better, is there some way to tell who (or what process) has it locked?
The way I've done this in the past is to have a Lock Table (This is only rational for critical tables), which has a Process ID, User ID, table and primary key value.