SQL Server Table Lock

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

What DBMS are you using?

I'm using SQL Server 7.0.

check out Tablock