----------------------------------------
Help on DBCC commands (SQL Server 2000)
----------------------------------------

activecursors [(spid)]

addextendedproc (function_name, dll_name)

addinstance (objectname, instancename)

adduserobject (name)

auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)

autopilot (typeid, dbid, tabid, indid, pages [,flag])

balancefactor (variance_percent)

bufcount [(number_of_buffers)]

buffer ( {'dbname' | dbid} [, objid [, number [, printopt={0|1|2} ][, dirty | io | kept | rlock | ioerr | hashed ]]])

bytes ( startaddress, length )

cachestats 

callfulltext  - system sp use only

checkalloc [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, ESTIMATEONLY]]
Repair Options - REPAIR_ALLOW_DATA_LOSS (default) | REPAIR_REBUILD | REPAIR_FAST

checkcatalog [('database_name')] [WITH NO_INFOMSGS]

checkconstraints [( 'tab_name' | tab_id | 'constraint_name' | constraint_id )] [WITH ALL_CONSTRAINTS | ALL_ERRORMSGS]

checkdb [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]
Repair Options - REPAIR_ALLOW_DATA_LOSS (default) | REPAIR_REBUILD | REPAIR_FAST

checkdbts (dbid, newTimestamp)

checkfilegroup [( [ {'filegroup_name' | filegroup_id} ] [, NOINDEX] )] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]

checkident ('table_name'[, { NORESEED | {RESEED [, new_reseed_value] } } ] )

checkprimaryfile ( {'FileName'} [, opt={0|1|2|3} ])

checktable ('table_name'[, {NOINDEX | index_id | REPAIR}]) [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]
Repair Options - REPAIR_ALLOW_DATA_LOSS (default) | REPAIR_REBUILD | REPAIR_FAST

cleantable ('database_name'|database_id, 'table_name'|table_id, [batch_size])

cacheprofile [( {actionid} [, bucketid])

clearspacecaches ('database_name'|database_id, 'table_name'|table_id, 'index_name'|index_id)

collectstats (on | off)

concurrencyviolation (reset | display | startlog | stoplog)

config 

cursorstats ([spid [,'clear']])

dbinfo [('dbname')]

dbrecover (dbname [, IgnoreErrors])

dbreindex ('table_name' [, index_name [, fillfactor ]]) [WITH NO_INFOMSGS]

dbreindexall (db_name/db_id, type_bitmap)

dbrepair ('dbname', DROPDB [, NOINIT])
DROP DATABASE is the preferred method of dropping a damaged database.
('dbname', readpage | writepage | repairindex | syscatfix | markdirty | dropdevice, int, int)

dbtable [({'dbname' | dbid})]

debugbreak 

deleteinstance (objectname, instancename)

des [( {'dbname' | dbid} [, {'objname' | objid} ])]

detachdb [( 'dbname' )]

dropcleanbuffers 

dropextendedproc (function_name)

dropuserobject ('object_name')

dumptrigger ({'BREAK', {0 | 1}} | 'DISPLAY' | {'SET', exception_number} | {'CLEAR', exception_number})

errorlog 

extentinfo [({'database_name'| dbid | 0} [, {'table_name' | table_id} [, {'index_name' | index_id | -1}]])]

fileheader [( {'dbname' | dbid} [, fileid])

fixallocation [({'ADD' | 'REMOVE'}, {'PAGE' | 'SINGLEPAGE' | 'EXTENT' | 'MIXEDEXTENT'}, filenum, pagenum [, objectid, indid])

flush ('data' | 'log', dbid)

flushprocindb (database)

free dll_name (FREE)
e.g. DBCC xp_sample (FREE)

freeproccache 

freeze_io (db)

getvalue (name)

help ('dbcc_command' | '?')

icecapquery ('dbname', stored_proc_name [, #_times_to_icecap  (-1 infinite, 0 turns off)])
Use 'dbcc icecapquery (printlist)' to see list of SP's to profile.
Use 'dbcc icecapquery (icecapall)' to profile all SP's.

incrementinstance (objectname, countername, instancename, value)

ind ( { 'dbname' | dbid }, { 'objname' | objid }, { indid | 0 | -1 | -2 } )

indexdefrag ({dbid | dbname | 0}, {tableid | tablename}, {indid | indname})

inputbuffer (spid)

invalidate_textptr (textptr)

invalidate_textptr_objid (objid)

iotrace ( { 'dbname' | dbid | 0 | -1 }, { fileid | 0 }, bufsize, [ { numIOs | -1 } [, { timeout (sec) | -1 } [, printopt={ 0 | 1 }]]] )

latch ( address [, 'owners'] [, 'stackdumps'])

lock ([{'DUMPTABLE' | 'DUMPSTATS' | 'RESETSTATS' | 'HASH'}]|[{'STALLREPORTTHESHOLD', stallthreshold}])

lockobjectschema ('object_name')

log ([dbid[,{0|1|2|3|4}[,['lsn','[0x]x:y:z']|['numrecs',num]|['xdesid','x:y']|['extent','x:y']|['pageid','x:y']|['objid',{x,'y'}]|['logrecs',{'lop'|op}...]|['output',x,['filename','x']]...]]])

loginfo [({'database_name' | dbid})]

memobjlist [(memory object)]

memorymap 

memorystatus 

memospy 

memusage ([IDS | NAMES], [Number of rows to output])

monitorevents ('sink' [, 'filter-expression'])

newalloc - please use checkalloc instead

no_textptr (table_id , max_inline)

opentran [({'dbname'| dbid})] [WITH TABLERESULTS[,NO_INFOMSGS]]

outputbuffer (spid)

page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0|1|2|3} ][, cache={0|1} ])

perflog 

perfmon 

pglinkage (dbid, startfile, startpg, number, printopt={0|1|2}, targetfile, targetpg, order={1|0})

pintable (database_id, table_id)

procbuf [({'dbname' | dbid}[, {'objname' | objid}[, nbufs[, printopt = { 0 | 1 } ]]] )]

proccache 

prtipage (dbid, objid, indexid [, [{{level, 0} | {filenum, pagenum}}] [,printopt]])

pss [(uid[, spid[, printopt = { 1 | 0 }]] )]

readpage ({ dbid, 'dbname' }, fileid, pageid, formatstr [, printopt = { 0 | 1} ])

rebuild_log (dbname [, filename])

renamecolumn (object_name, old_name, new_name)

resource 

row_lock (dbid, tableid, set) - Not Needed

ruleoff ({ rulenum | rulestring } [, { rulenum | rulestring } ]+)

ruleon (  rulenum | rulestring } [, { rulenum | rulestring } ]+)

setcpuweight (weight)

setinstance (objectname, countername, instancename, value)

setioweight (weight)

show_statistics ('table_name', 'target_name')

showcontig (table_id | table_name [, index_id | index_name] [WITH FAST, ALL_INDEXES, TABLERESULTS [,ALL_LEVELS]])

showdbaffinity 

showfilestats [(file_num)]

showoffrules 

showonrules 

showtableaffinity (table)

showtext ('dbname', {textpointer | {fileid, pageid, slotid [,option]}})

showweights 

shrinkdatabase ({dbid | 'dbname'}, [freespace_percentage [, {NOTRUNCATE | TRUNCATEONLY}]])

shrinkdb  is no longer supported. Please use shrinkdatabase instead

shrinkfile ({fileid | 'filename'}, [compress_size [, {NOTRUNCATE | TRUNCATEONLY | EMPTYFILE}]])

sqlmgrstats 

sqlperf (LOGSPACE)
({IOSTATS | LRUSTATS | NETSTATS | RASTATS [, CLEAR]} | {THREADS} | {LOGSPACE})

stackdump [( {uid[, spid[, ecid]} | {threadId, 'THREADID'}] )]

tab ( dbid, objid )

tape_control {'query' | 'release'}[,('\\.\tape<n>')]

tec [( uid[, spid[, ecid]] )]

textall [({'database_name'|database_id}[, 'FULL' | FAST] )]

textalloc ({'table_name'|table_id}[, 'FULL' | FAST])

thaw_io (db)

traceoff [( tracenum [, tracenum ... ] )]

traceon [( tracenum [, tracenum ... ] )]

tracestatus (trace# [, ...trace#])

unpintable (dbid, table_id)

updateusage ({'database_name'| 0} [, 'table_name' [, index_id]]) [WITH [NO_INFOMSGS] [,] COUNT_ROWS]

upgradedb (db)

usagegovernor (command, value)

useplan [(number_of_plan)]

useroptions 

wakeup (spid)

writepage ({ dbid, 'dbname' }, fileid, pageid, offset, length, data)