SQL Server Performance Forum – Threads Archive
syslockinfo rsc_objidHi, 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 kBAhttp://support.microsoft.com/kb/271509 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.