Find table locks

Find SQL table locks

select b.[name], a.*
from sys.dm_tran_locks a
left outer join sys.sysobjects b on a.resource_associated_entity_id = b.id
where a.resource_database_id = 80
       and a.resource_type = 'OBJECT'