SQL Server Performance Forum – Threads Archive

How to find an Object id with the help of a Pageid

How to find out an object id with the help of a pageid For ex: Is it possible with the message Could not retrieve row from logical page (0:75839) by RID because the entry in the offset table (16) for that RID (885240692) is less than or equal to 0.. with the above message is it possible to find object id.
Rushendra

---

Refer to BOL for OBJECT_ID & OBJECT_NAME function.
Run DBCC checks against that table and CHECKDB with REPAIR clause to get rid of the error. _________
Satya SKJ

---

Just to satify your curiosity about the Object ID. If you know the Page ID (which in this case you don’t – what you have there is not a physical page id), and the file on which the object is located then, apart from Satya’s appropriate suggestion you can also use the DBCC PAGE command. No point of trying this in your case. NHO

---

]]>