SQL Server Performance

How do find the object name or Object Id by Page ID in SQL 2005?

Discussion in 'SQL Server 2005 General DBA Questions' started by amitadmin, Jan 9, 2009.

  1. amitadmin New Member

    Hi Friend,
    I have the following things however I am not able to find out the Object ID and Object Id Name by Page ID in SQL 2005.
    • Database ID
    • Database Name
    • Page ID
    • Associated objid
    Please help me to resolve this issue ASAP it would be appreciated.
  2. Elisabeth Redei New Member

    Hi,
    You can use the un-everything command (well documented on the web though) DBCC PAGE (dbid, fileid, pageid) as in:dbcc
    page (15, 1,2236) with tableresults
    HTH
    /Elisabeth

Share This Page