LOCKTABLE and username

Sbhat

Hi -

I have a LOCKTABLE function in my code and system gives a message when 2 users try to user the same table. Is there any way to flag the username that has locked the table to the other user programatically.

Thanks
S.

matttrax

No, you can't have the message show you who has you blocked. You can however view this information in the Session table or in SQL (sp_who command)