The HoBtID and the associated objid are not the same number.

MTM

Using 2005. Neither query you provided return any information at all.

MTM

Ignore that. Looking in the wrong database.

Scratch that too. I think my eyes are going squirrelly from looking at too
many really long numbers.

MTM

That's why I put "ObjectID" in quotes, as earlier you claimed the ObjectID
was 72057647487385600, which was clearly the HoBt ID (partition_id).


On 6/16/09 3:16 PM, in article #kyCubr7JHA.5828 (AT) TK2MSFTNGP04 (DOT) phx.gbl,
"Michael MacGregor" <macnoknifespam (AT) noemailspam (DOT) com> wrote:

The number provided is given as both the HoBtID and the associated objid,
but I took it from the associated objid originally.

MTM

Ok, I have a different resource node set of data for a Page Lock that has
the same associated objid number along with DB ID, File ID and Page ID. What
would the associated objid be in this case?

MTM

What does the following yield:

DBCC PAGE(DB ID, File ID, Page ID) WITH TABLERESULTS;

?

Hint: you should get a row with the following column values:

ParentObject = "PAGE HEADER:"
Field = "Metadata: ObjectId"
VALUE = <the real object_id>







On 6/20/09 7:40 PM, in article OaWGvBg8JHA.1380 (AT) TK2MSFTNGP02 (DOT) phx.gbl,
"Michael MacGregor" <nospam (AT) nospam (DOT) com> wrote: