Monday, March 5, 2012

object_name function

object_name has a problem - it takes an int as an argument and some objects in sql server are larger (how's that?)

I do a join instead

regarder:

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


No comments:

Post a Comment