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
Sat

---

See this kBAhttp://support.microsoft.com/kb/271509 for that pss blocker script. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.

---

]]>