Find resource currently involved in blocking Jan 10, 2014 Lincoln Bovee' SELECT DISTINCT objname = object_name(p.object_id) FROM sys.partitions p JOIN sys.dm_tran_locks t1 ON p.hobt_id = t1.resource_associated_entity_id 1234 SELECT DISTINCT objname = object_name(p.object_id)FROM sys.partitions pJOIN sys.dm_tran_locks t1ON p.hobt_id = t1.resource_associated_entity_id Views – 1660