rint (default).
logical (optional) type of page 0 pagenum is taken to a virtual page
number
1 pagenum is taken to be a logical page number (default)
dbcc pglinkage ( dbid, start, number, printopt, target, order )
Display the page chain, performing integrity checks during traversal.
Parameters
ParamDescriptionValid Values
dbid database ID
start page number with which to start
number number of pages to examine, or 0 if target is specified
printopt print option 0 display only the count of pages scanned
1 display information about the last 16 pages scanned
2 display all page numbers in the scan
target the particular page we are looking for, or 0 if number is specified
Specifying a target will continue to search in the specified direction
until the target page or the end of the chain is found.
ordertraversal order0 descending
1 ascending
dbcc pktmemshow ( [spid] )
Lists network buffers for active processes.
Parameters
ParamDescription
spid (optional) server process ID
dbcc procbuf ( [ dbid] [, objid] [, nbufs] [, printopt ] )
Print procedure buffer headers and proc-headers from the procedure cache.
Parameters
ParamDescriptionValid Values
dbid (optional) database ID
objid (optional) object ID
nbufs (optional) number of buffers to print
printopt (optional) print option 0 print out only the proc buff and proc
header (default)
1 print out proc buff, proc header and contents of buffer.
dbcc procdiag ( dbid, option )
Produce diagnostics on procedure buffers
Parameters
ParamDescriptionValid Values
dbid database ID
optiondiagnostic to run 0 display option menu
1 display diag bitmaps
2 display procbufs in cache
3 run summary diagnostics on entire cache
dbcc prtipage ( dbid, objid, indexid, indexpage )
Print the page number pointed to by each row on the specified index page.
Parameters
ParamDescription
dbid database ID
objid object ID
indexid index ID
indexpage the logical page number of the index page to dump
dbcc pss ( suid, spid, printopt )
Prints the contents of the specified PSS structure.
Parameters
ParamDescriptionValid Values
suid (optional) server user ID
spid (optional) server process ID
printopt print option 0 standard output
1 all open DES's and current sequence tree
2 print all locks held by the process to the errorlog.
dbcc rebuild_log ( dbname, rebuild, all )
Generates a new log containing a single checkpoint record.
Parameters
ParamDescriptionValid Values
dbname database name
rebuild rebuild log flag 0 do not create a new log
1 create a new log
all remove log flag 0 old preserved log removed
1 old preserved and new log removed
dbcc rebuildextents ( dbid, objid, indexid, sort, override )
Rebuild an object's extent chain.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
indexid index ID
sort state of the sort bit0 sorted
1not sorted
override override option 0 rebuild only if database is not open
1 rebuild even though database is already open
dbcc reindex ( tablename )
Rebuilds indexes.
Parameters
ParamDescription
tablename table whose indexes are to be rebuilt
dbcc remap ( objid, dbname, 1 )
Remaps a stored proc, trigger, rule, default, or view to be compatible with
release 10.0.
Parameters
ParamDescription
objid object ID
dbname database name
dbcc report_al [( dbname )]
Report on differences between allocation bitmaps and page chains.
Parameters
ParamDescription
dbname (optional) database name
dbcc resource
Print out the RESOURCE structure.
dbcc save_rebuild_log ( dbname )
Generate a new log containing a single checkpoint record and preserve old log
extents by changing the object ID.
Parameters
ParamDescription
dbname database&