Who has the row locked?

From: Massis Isagholian <massis_at_att.com>
Date: Thu, 07 Nov 2002 20:11:37 GMT
Message-ID: <ZNzy9.399$hK4.31751@bgtnsc05-news.ops.worldnet.att.net>

I have an application that needs to determine what process has locked a specific row on given table. My application needs to retrieve the following information from the database server:

    Session ID
    Session Status
    DBase User ID
    OS User ID
    OS Process ID
    Machine Name (client)
    Program Name (ex: myprogram.exe)
    Other lock related info as appropriate

My application is not thread-safe, hence, I prefer not to use multiple threads to obtain the information listed above.

I'd appreciate your quick response.

Thanks,
Massis Received on Thu Nov 07 2002 - 14:11:37 CST