MS SQL Server - Page ID to Object ID

Author

Page ID to Object ID

Frank Rizzo

2006-01-26, 4:53 pm

I have a page id. How can I find out what object it belongs to?
I am running Sql2k.

Thanks

Kalen Delaney

2006-01-26, 4:53 pm

You'll have to use the undocumented DBCC PAGE command.
You can google it and find places where it has been discussed, including in
my Inside SQL Server book and several articles I have written for SQL Server
Magazine.

The object ID shows up in the PAGE HEADER section, and then you can use the
documented object_name function to get the object name.

--
HTH
Kalen Delaney, SQL Server MVP
www. solidqualitylearning
.com

"Frank Rizzo" <none@none.com> wrote in message
news:O$dLkthIGHA.2460@TK2MSFTNGP10.phx.gbl...
>I have a page id. How can I find out what object it belongs to?
> I am running Sql2k.
>
> Thanks

Jasper Smith

2006-01-26, 4:53 pm

sp_object_from_page
http://www.sqldbatips.com/displaycode.asp?ID=5

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

"Frank Rizzo" <none@none.com> wrote in message
news:O$dLkthIGHA.2460@TK2MSFTNGP10.phx.gbl...
>I have a page id. How can I find out what object it belongs to?
> I am running Sql2k.
>
> Thanks

Sponsored Links