[code=sql]
select tb.name, ta.resource_type,
ta.resource_database_id,
ta.resource_description,
ta.resource_associated_entity_id,
ta.request_mode,
ta.request_type,
ta.request_status,
ta.request_session_id,
ta.request_owner_type
from sys.dm_tran_locks ta
left join sys.databases tb on tb.database_id = ta.resource_database_id
order by tb.name
[/code]
select tb.name, ta.resource_type,
ta.resource_database_id,
ta.resource_description,
ta.resource_associated_entity_id,
ta.request_mode,
ta.request_type,
ta.request_status,
ta.request_session_id,
ta.request_owner_type
from sys.dm_tran_locks ta
left join sys.databases tb on tb.database_id = ta.resource_database_id
order by tb.name
[/code]