Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

DbccCommand Enumeration

Specifies the Dbcc commands.

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

public enum DbccCommand

Member nameDescription
ActiveCursorsThe command is ActiveCursors.
AddExtendedProcThe command is AddExtendedProc.
AddInstanceThe command is AddInstance.
AuditEventThe command is AuditEvent.
AutoPilotThe command is AutoPilot.
BufferThe command is Buffer.
BytesThe command is Bytes.
CacheProfileThe command is CacheProfile.
CacheStatsThe command is CacheStats.
CallFullTextThe command is CallFullText.
CheckAllocThe command is CheckAlloc.
CheckCatalogThe command is CheckCatalog.
CheckConstraintsThe command is CheckConstraints.
CheckDBThe command is CheckDB.
CheckFileGroupThe command is CheckFileGroup.
CheckIdentThe command is CheckIdent.
CheckPrimaryFileThe command is CheckPrimaryFile.
CheckTableThe command is CheckTable.
CleanTableThe command is CleanTable.
ClearSpaceCachesThe command is ClearSpaceCaches.
CollectStatsThe command is CollectStats.
ConcurrencyViolationThe command is ConcurrencyViolation.
CursorStatsThe command is CursorStats.
DBRecoverThe command is DBRecover.
DBReindexThe command is DBReindex.
DBReindexAllThe command is DBReindexAll.
DBRepairThe command is DBRepair.
DebugBreakThe command is DebugBreak.
DeleteInstanceThe command is DeleteInstance.
DetachDBThe command is DetachDB.
DropCleanBuffersThe command is DropCleanBuffers.
DropExtendedProcThe command is DropExtendedProc.
DumpConfigThe command is DumpConfig.
DumpDBInfoThe command is DumpDBInfo.
DumpDBTableThe command is DumpDBTable.
DumpLockThe command is DumpLock.
DumpLogThe command is DumpLog.
DumpPageThe command is DumpPage.
DumpResourceThe command is DumpResource.
DumpTriggerThe command is DumpTrigger.
ErrorLogThe command is ErrorLog.
ExtentInfoThe command is ExtentInfo.
FileHeaderThe command is FileHeader.
FixAllocationThe command is FixAllocation.
FlushThe command is Flush.
FlushProcInDBThe command is FlushProcInDB.
ForceGhostCleanupThe command is ForceGhostCleanup.
FreeThe command is Free.
FreeProcCacheThe command is FreeProcCache.
FreeSessionCacheThe command is FreeSessionCache.
FreeSystemCacheThe command is FreeSystemCache.
FreezeIOThe command is FreezeIO.
HelpThe command is Help.
IcecapQueryThe command is IcecapQuery.
IncrementInstanceThe command is IncrementInstance.
IndThe command is Ind.
IndexDefragThe command is IndexDefrag.
InputBufferThe command is InputBuffer.
InvalidateTextptrCommand is InvalidateTextptr.
InvalidateTextptrObjidThe command is InvalidateTextptrObjid.
LatchThe command is Latch.
LogInfoThe command is LogInfo.
MapAllocUnitThe command is MapAllocUnit.
MemObjListThe command is MemObjList.
MemoryMapThe command is MemoryMap.
MemoryStatusThe command is MemoryStatus.
MetadataThe command is Metadata.
MovePageThe command is MovePage.
NoneThe command is None.
NoTextptrThe command is NoTextptr.
OpenTranThe command is OpenTran.
OptimizerWhatIfThe command is OptimizerWhatIf.
OutputBufferThe command is OutputBuffer.
PerfMonStatsThe command is PerfMonStats.
PersistStackHashThe command is PersistStackHash.
PinTableThe command is PinTable.
ProcCacheThe command is ProcCache.
PrtiPageThe command is PrtiPage.
ReadPageThe command is ReadPage.
RenameColumnThe command is RenameColumn.
RuleOffThe command is RuleOff.
RuleOnThe command is RuleOn.
SeMetadataThe command is SeMetadata.
SetCpuWeightThe command is SetCpuWeight.
SetInstanceThe command is SetInstance.
SetIOWeightThe command is SetIOWeight.
ShowContigThe command is ShowContig.
ShowDBAffinityThe command is ShowDBAffinity.
ShowFileStatsThe command is ShowFileStats.
ShowOffRulesThe command is ShowOffRules.
ShowOnRulesThe command is ShowOnRules.
ShowStatisticsThe command is ShowStatistics.
ShowTableAffinityThe command is ShowTableAffinity.
ShowTextThe command is ShowText.
ShowWeightsThe command is ShowWeights.
ShrinkDatabaseThe command is ShrinkDatabase.
ShrinkFileThe command is ShrinkFile.
SqlMgrStatsThe command is SqlMgrStats.
SqlPerfThe command is SqlPerf.
StackDumpThe command is StackDump.
TecThe command is Tec.
ThawIOThe command is ThawIO.
TraceOffThe command is TraceOff.
TraceOnThe command is TraceOn.
TraceStatusThe command is TraceStatus.
UnpinTableThe command is UnpinTable.
UpdateUsageThe command is UpdateUsage.
UsePlanThe command is UsePlan.
UserOptionsThe command is UserOptions.
WritePageThe command is WritePage.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft