功能: 查看数据页面
使用:
1. 首先打开3604跟踪功能
dbcc traceon(3604)
2. 语法:
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
例:数据库名称:"testdb2",数据文件ID:"1",Page页号:216
查询命令为:
dbcc page('testdb2', 1, 216, 3)