SQL Server Table Lock

[tomtan]

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

[JHausmann]

What DBMS are you using?

[tomtan]

I'm using SQL Server 7.0.

[Clunietp]

check out Tablock