DBCC PAGE

功能： 查看数据页面

 

使用：

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)