DBCC Page

[seekwall]

Does anyone know of an intuitive algoritm (text) that I can use to write a procedure that strips out the Page Id from the first field in sysindexes ? I need this in order to be able to use DBCC Page

There is no info in BOL, and the hard copy books I have seem to contradict each other.

Thanks in Advance

 

[SQLBill]

Have you tried a simple select statement?

SELECT id FROM sysindexes WHERE name = 'table_name'

-SQLBill

 

[seekwall]

I need to be able to convert the Hexadecimal values from the first field in sysindexes to the decimal values of the File and page address. The first field (I believe) references the first page within a table

This hasn't got anything to do with object ID's