SQL SERVER:DBCC PAGE
dbcc page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0|1|2|3} ])
The printopt parameter has the following meanings:
- 0 - print just the page header
- 1 - page header plus per-row hex dumps and a dump of the page slot array (unless its a page that doesn't have one, like allocation bitmaps)
- 2 - page header plus whole page hex dump
- 3 - page header plus detailed per-row interpretation
示例:
dbcc traceon(3604) dbcc page(test,1,10964034,1)
注:首先要开启3604跟踪标志,否则dbcc page命令不会把结果返回到客户端。