Purpose: Prints the contents of a page within a database.
Usage:
dbcc page (dbid, pageno,[printopt [,cache [,logical [,cachename]]]])
or
dbcc page (dbname, pageno,[printopt [,cache [,logical [,cachename]]]])
dbid - database ID
dbname - database name
pageno - page number
printopt - output format:
0 - print buffer and page header only (default)
1 - print buffer and page headers, rows and
offset table
2 - print buffer and page headers, hex dump
of data and offset table
cache - where to get the page:
0 - read page from disk
1 - read page from cache if present, otherwise
read from disk (default)
logical - the page type
0 - pageno is a virtual page
1 - pageno is a logical page (default)
cachename - the cache name
-1 - all caches