June 1, 2006 at 4:45 am
I want to view the content of the datapage by using the following DBCC PAGE command
DBCC PAGE ('test', 1, 256)
where test is the Name of the database, 1 is the file Id, 256 is the Page Number which is available in First column of Sysindexes table. But it gies the following error:
Server: Msg 8968, Level 16, State 1, Line 1
Table error: DBCC PAGE page (2:256) (object ID 0, index ID 0) is out of the range of this database.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Can any body tell me how to find out the File Id ?
June 1, 2006 at 5:19 am
select file_id('logical filename').
Or select * from sysfiles.
However, your problem seems to be your interpretation of Page Number. Page Number is not dreived from the first column in sysindexes. The first column in sysindexes tells you the object_id of object to which a given index belongs.
Page Number is just that, the page number that you wish to retrieve information on.
Perhaps your database doesn't have 256 pages? Try this:
DBCC PAGE ('test', 1, 1)
Hope that helps,
June 1, 2006 at 5:30 am
Hi Karl,
Thankx a lot. It worked.
Thanks once again....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply