code to replace deprecated sp_lock

select  request_session_id,

resource_database_id,

resource_associated_entity_id,

--object_name(resource_associated_entity_id),

o.name,

request_mode,

request_status

from sys.dm_tran_locks l left join sys.objects o

on l.resource_associated_entity_id = o.object_id