syslockinfo rsc_objid | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

syslockinfo rsc_objid

Hi, How can I get the right object_name of rsj_objid column in SELECT statement using master database. Is there any another function like object_name but with database id parameter? SELECT object_name(rsc_objid) FROM syslockinfo Thanks
Hi U can also do this select * from sysojects where name like <object_name> Cheers
See this kBA for that pss blocker script. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.