Hi,

Anyone knows how to check whether a table is being lock by other users?

If a user uses this query:

BEGIN TRANSACTION
UPDATE Table WITH(HOLDLOCK) SET Field = 'Test'

How to know whether that table is Locked or not?

Please help. Thanks