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

dbcc activecursors [(spid)]

dbcc addextendedproc (function_name, dll_name)

dbcc addinstance (objectname, instancename)

dbcc auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid, objname, servername, providername)

dbcc autopilot (typeid [, dbid [, {maxQueryCost | tabid [, indid [, pages [, flag [, rowcounts]]]]} ]])

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

dbcc bytes ( startaddress, length )

dbcc cacheprofile ( actionid [, bucketid])

dbcc cachestats 

dbcc callfulltext  - system sp use only

dbcc checkalloc 
(
     [ { 'database_name' | database_id | 0 } ]
     [ , NOINDEX |
     { REPAIR_ALLOW_DATA_LOSS
     | REPAIR_FAST
     | REPAIR_REBUILD
     } ]
)
     [ WITH
         {
             [ ALL_ERRORMSGS ]
           	 [ , [ NO_INFOMSGS ] ]
           	 [ , [ TABLOCK ] ]
             [ , [ ESTIMATEONLY ] ]
         }
     ]

dbcc checkcatalog 
[
    ( { 'database_name' | database_id | 0 } )
]
    [ WITH NO_INFOMSGS ]

dbcc checkconstraints 
[
    ( { 'table_name' | table_id | 'constraint_name' | constraint_id } )
]
    [ WITH
        { ALL_CONSTRAINTS | ALL_ERRORMSGS }
        [ , [ NO_INFOMSGS ] ]
    ]

dbcc checkdb 
(
    { 'database_name' | database_id | 0 }
    [ , NOINDEX
    | { REPAIR_ALLOW_DATA_LOSS
    | REPAIR_FAST
    | REPAIR_REBUILD
    } ]
)
    [ WITH
        {
            [ ALL_ERRORMSGS ]
            [ , [ NO_INFOMSGS ] ]
            [ , [ TABLOCK ] ]
            [ , [ ESTIMATEONLY ] ]
            [ , [ PHYSICAL_ONLY ] ]
            [ , [ DATA_PURITY ] ]
        }
    ]

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

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

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

dbcc checktable 
(
    { 'table_name' | 'view_name' }
    [ , NOINDEX
    | index_id
    | { REPAIR_ALLOW_DATA_LOSS
    | REPAIR_FAST
    | REPAIR_REBUILD
    } ]
)
    [ WITH
        {
            [ ALL_ERRORMSGS ]
            [ , [ NO_INFOMSGS ] ]
            [ , [ TABLOCK ] ]
            [ , [ ESTIMATEONLY ] ]
            [ , [ PHYSICAL_ONLY ] ]
        }
    ]

dbcc cleantable 
(
    { 'database_name' | database_id | 0 }
    , { 'table_name' | table_id | 'view_name' | view_id }
    [ , batch_size ]
)
    [ WITH NO_INFOMSGS ]

dbcc clearspacecaches ('dbname'|dbid, 'table_name'|table_id, 'index_name'|index_id [, partition_number])

dbcc collectstats (on | off)

dbcc concurrencyviolation ( reset | display | startlog | stoplog )

dbcc config 

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

dbcc dbinfo [('dbname')]

dbcc dbrecover (dbname [, IgnoreErrors])

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

dbcc dbreindexall (dbname|dbid[, type_bitmap])

dbcc dbrepair ('dbname', markdirty | {dropdevice, int} | {repairindex, int, int})

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

dbcc debugbreak 

dbcc deleteinstance (objectname, instancename)

dbcc detachdb ( 'dbname' [, fKeep_Fulltext_Index_File (0 | 1)] )

dbcc dropcleanbuffers [ WITH NO_INFOMSGS ]

dbcc dropextendedproc (function_name)

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

dbcc errorlog 

dbcc extentinfo [({'dbname'| dbid | 0} [, {'tablename' | tableid} [, {'indexname' | indexid | -1} [, partition_number]]])]

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

dbcc fixallocation [({'ADD' | 'REMOVE'}, {'PAGE' | 'SINGLEPAGE' | 'EXTENT' | 'MIXEDEXTENT'}, filenum, pagenum [, objectid, indexid, partitionid, allocUnitId])

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

dbcc flushprocindb (dbid)

dbcc forceghostcleanup [({'dbname' | dbid})]

dbcc dll_name( FREE ) [ WITH NO_INFOMSGS ]
e.g. dbcc xp_sample( FREE )

dbcc freeproccache [ WITH NO_INFOMSGS ]

dbcc freesessioncache 

dbcc freesystemcache 
(
    'ALL'
)
    [ WITH
        {
            [ MARK_IN_USE_FOR_REMOVAL ]
            [, [ NO_INFOMSGS ] ]
        }
    ]

dbcc freeze_io (dbname | dbid)

dbcc help 
(
    { 'dbcc_statement' | @dbcc_statement_var | '?' }
)
    [ WITH NO_INFOMSGS ]

dbcc 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.

dbcc incrementinstance (objectname, countername, instancename, value)

dbcc ind ( { 'dbname' | dbid }, { 'objname' | objid }, { nonclustered indid | 1 | 0 | -1 | -2 } [, partition_number] )

dbcc indexdefrag 
(
    { 'database_name' | database_id | 0 }
    , { 'table_name' | table_id | 'view_name' | view_id }
    , { 'index_name' | index_id }
    , { partition_number | 0 }
)
    [ WITH NO_INFOMSGS ]

dbcc inputbuffer 
(
    session_id [ , request_id ]
)
    [WITH NO_INFOMSGS ]

dbcc invalidate_textptr (textptr)

dbcc invalidate_textptr_objid (objid)

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

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

dbcc log (dbname | 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']]...]]])

dbcc loginfo [({'dbname' | dbid})]

dbcc mapallocunit (I8AllocUnitId | {I4part, I2part})

dbcc memobjlist [(memory object)]

dbcc memorymap 

dbcc memorystatus 

dbcc metadata ({'print' [, printopt = {0 |1}] | 'drop' | 'clone' [, '<NewObjectName>' | ....]}, {'object' [, 'type',...}, {Id | Name}, [{Ownerid | Ownername}], [{Dbid | Dbname}]])

dbcc movepage ( {'dbname' | dbid}, src_filenum, src_pagenum [, des_filenum [, des_pagenum [, des_pagenum2]]]) [WITH NO_INFOMSGS]

dbcc no_textptr (table_id , max_inline)

dbcc opentran 
[
    ( [ { 'database_name' | database_id | 0 } ] )
]
    [ WITH
        {
            [ TABLERESULTS ]
            [ , [ NO_INFOMSGS ]
        }
    ]

dbcc optimizer_whatif property, value

dbcc outputbuffer 
(
    session_id [ , request_id ]
)
    [ WITH NO_INFOMSGS ]

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

dbcc perfmon 

dbcc persiststackhash (input_hashfile, BUFLATCH_TIMEOUT | ATTENTION | OUTOFLOCKS | LATCH_ATTN | OUTOFLOG | OUTOFMEM | SOS | NO_BUFFS [, SKIPLAST | INCLUDELAST] [,output_hashfile])

dbcc pintable (database_id, table_id)

dbcc proccache [ WITH NO_INFOMSGS ]

dbcc prtipage (dbname | dbid, objid | objname, indexid | indexname	[, partition_number [, level]]). No partition specified uses the first partition. No level specified prints root page.

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

dbcc renamecolumn (object_name, old_name, new_name)

dbcc resource 

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

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

dbcc semetadata (object id | name, index id | name [, partition id])

dbcc setcpuweight (weight)

dbcc setinstance (objectname, countername, instancename, value)

dbcc setioweight (weight)

dbcc show_statistics 
(
    { 'table_name' | 'view_name' }
    , target
)
    [ WITH
        {
            [ NO_INFOMSGS ]
            < option > [ , n ]
        }
    ]
< option > ::=
    STAT_HEADER | DENSITY_VECTOR | HISTOGRAM

dbcc showcontig 
[ (
    { 'table_name' | table_id | 'view_name' | view_id }
    [ , { 'index_name' | index_id } ]
) ]
    [ WITH
        {
            [ ALL_INDEXES
            | FAST [ , ALL_INDEXES ]
            | TABLERESULTS [ , { ALL_INDEXES } ] ]
            [ , { FAST | ALL_LEVELS } ]
            [ , NO_INFOMSGS ]
        }
    ]

dbcc showdbaffinity 

dbcc showfilestats [(file_num)]

dbcc showoffrules 

dbcc showonrules 

dbcc showtableaffinity (table_id | table_name [, partition_number])

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

dbcc showweights 

dbcc shrinkdatabase 
(
    { 'database_name' | database_id | 0 }
    [ , target_percent ]
    [ , { NOTRUNCATE | TRUNCATEONLY } ]
)
    [ WITH NO_INFOMSGS ]

dbcc shrinkfile 
(
    { 'file_name' | file_id }
    {
        [ , EMPTYFILE]
        | [ [, target_size ] [ , { NOTRUNCATE | TRUNCATEONLY } ] ]
    }
)
    [ WITH NO_INFOMSGS ]

dbcc sqlmgrstats 

dbcc sqlperf ( LOGSPACE ) [ WITH NO_INFOMSGS ]

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

dbcc stackdump [( ['dump description',] {{uid[, spid [, batchid [, ecid]]} | {threadId, 'THREADID'}]} )]

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

dbcc thaw_io (dbname | dbid)

dbcc traceoff 
(
    trace# [ , ...n ] [, -1]
)
    [ WITH NO_INFOMSGS ]

dbcc traceon 
(
    trace# [ , ...n ] [, -1]
)
    [ WITH NO_INFOMSGS ]

dbcc tracestatus 
(
    [ [ trace# [ , ...n ] ] [ , -1 ] ]
)
    [ WITH NO_INFOMSGS ]

dbcc unpintable (dbid, table_id)

dbcc updateusage 
(
    { 'database_name' | database_id | 0 }
    [ , { 'table_name' | 'view_name' | object_id }
    [ , { 'index_name' | index_id } ] ]
)
    [ WITH
        {
            [ NO_INFOMSGS ]
            [ , [ COUNT_ROWS ] ]
        }
    ]

dbcc useplan [(number_of_plan)]

dbcc useroptions [ WITH NO_INFOMSGS ]

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