SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Technical Reference

SQL Server Management Objects (SMO) Class Library

Microsoft.SqlServer.Management.Smo Namespace

AbstractCollectionBase Class

ActivationExecutionContext Enumeration

AffinityInfo Class

AffinityType Enumeration

ApplicationRole Class

ApplicationRoleCollection Class

ApplicationRoleEvents Class

ArrayListCollectionBase Class

AssemblyAlterOptions Enumeration

AssemblySecurityLevel Enumeration

AsymmetricKey Class

AsymmetricKeyCollection Class

AsymmetricKeyEncryptionAlgorithm Enumeration

AsymmetricKeySourceType Enumeration

AsyncStatus Class

AttachOptions Enumeration

Audit Class

AuditActionType Enumeration

AuditCollection Class

AuditDestinationType Enumeration

AuditExtender Class

AuditFileSizeUnit Enumeration

AuditLevel Enumeration

AuditSpecification Class

AuditSpecificationDetail Structure

AuditStatusType Enumeration

Backup Class

BackupActionType Enumeration

BackupCompressionOptions Enumeration

BackupDevice Class

BackupDeviceCollection Class

BackupDeviceItem Class

BackupDeviceList Class

BackupDeviceType Enumeration

BackupRestoreBase Class

BackupRestoreBase.AsyncOperation Enumeration

BackupSetFlag Enumeration

BackupSetType Enumeration

BackupTruncateLogType Enumeration

CatalogPopulationAction Enumeration

CatalogPopulationStatus Enumeration

Certificate Class

CertificateCollection Class

CertificateEvents Class

CertificateSourceType Enumeration

ChangeTracking Enumeration

Check Class

CheckCollection Class

CollationVersion Enumeration

CollectionNotAvailableException Class

Column Class

ColumnCollection Class

CompatibilityLevel Enumeration

ConfigProperty Class

ConfigPropertyCollection Class

Configuration Class

ConfigurationBase Class

Cpu Class

CpuCollection Class

CreateDispositionType Enumeration

Credential Class

CredentialCollection Class

CryptographicProvider Class

CryptographicProviderCollection Class

DatabaseActiveDirectory Class

DatabaseAdapter Class

DatabaseAdapterBase Class

DatabaseAuditSpecification Class

DatabaseAuditSpecificationCollection Class

DatabaseAuditSpecificationExtender Class

DatabaseCollection Class

DatabaseDdlTrigger Class

DatabaseDdlTriggerCollection Class

DatabaseDdlTriggerEvent Class

DatabaseDdlTriggerEventSet Class

DatabaseDdlTriggerExecutionContext Enumeration

DatabaseEncryptionAlgorithm Enumeration

DatabaseEncryptionKey Class

DatabaseEncryptionKeyExtender Class

DatabaseEncryptionState Enumeration

DatabaseEncryptionType Enumeration

DatabaseEvent Class

DatabaseEventArgs Class

DatabaseEvents Class

DatabaseEventSet Class

DatabaseEventType Enumeration

DatabaseFile Class

DatabaseFileMappingsDictionary Class

DatabaseMaintenanceAdapter Class

DatabaseMapping Class

DatabaseMirroringPayload Class

DatabaseObjectTypes Enumeration

DatabaseOptions Class

DatabasePerformanceAdapter Class

DatabasePermission Class

DatabasePermissionInfo Class

DatabasePermissionSet Class

DatabasePermissionSetValue Enumeration

DatabaseRole Class

DatabaseRoleCollection Class

DatabaseSecurityAdapter Class

DatabaseSnapshotExtender Class

DatabaseStatus Enumeration

DatabaseUserAccess Enumeration

DataCompressionType Enumeration

DataFileCollection Class

DdlTextParserHeaderInfo Structure

DdlTriggerBase Class

Default Class

DefaultCollection Class

DefaultConstraint Class

DefaultRuleBase Class

DependencyCollection Class

DependencyCollectionNode Class

DependencyNode Class

DependencyTree Class

DependencyTreeNode Class

DependencyType Enumeration

DependencyWalker Class

DeviceType Enumeration

Edition Enumeration

EndpointAuthenticationOrder Enumeration

EndpointCollection Class

EndpointEncryption Enumeration

EndpointEncryptionAlgorithm Enumeration

EndpointPayload Class

EndpointProtocol Class

EndpointState Enumeration

EndpointType Enumeration

EventProperty Class

EventPropertyCollection Class

EventSetBase Class

EventType Enumeration

ExecutionContext Enumeration

ExecutionStatus Enumeration

ExtendedProperty Class

ExtendedPropertyCollection Class

ExtendedStoredProcedure Class

ExtendedStoredProcedureCollection Class

FailedOperationException Class

FileGroup Class

FileGroupCollection Class

FileGrowthType Enumeration

FilestreamAccessLevelType Enumeration

FileStreamEffectiveLevel Enumeration

FileStreamLevel Enumeration

ForeignKey Class

ForeignKeyAction Enumeration

ForeignKeyCollection Class

ForeignKeyColumn Class

ForeignKeyColumnCollection Class

FragmentationOption Enumeration

FrequencyPair Class

FullTextCatalog Class

FullTextCatalogCollection Class

FullTextCatalogUpgradeOption Enumeration

FullTextIndex Class

FullTextIndexColumn Class

FullTextIndexColumnCollection Class

FullTextService Class

FullTextStopList Class

FullTextStopListCollection Class

HttpAuthenticationModes Enumeration

HttpPortTypes Enumeration

HttpProtocol Class

IColumnPermission Interface

IDatabaseMaintenanceFacet Interface

IDatabaseOptions Interface

IDatabasePerformanceFacet Interface

IDatabaseSecurityFacet Interface

IExtendedProperties Interface

ILoginOptions Interface

ImplementationType Enumeration

IMultipartNameFacet Interface

INameFacet Interface

Index Class

IndexCollection Class

IndexedColumn Class

IndexedColumnCollection Class

IndexEnableAction Enumeration

IndexEvents Class

IndexKeyType Enumeration

IndexOperation Enumeration

IndexPopulationAction Enumeration

IndexPopulationStatus Enumeration

InDoubtTransactionResolutionType Enumeration

Information Class

InternalSmoErrorException Class

InvalidSmoOperationException Class

InvalidVersionSmoOperationException Class

IObjectPermission Interface

IScriptable Interface

IServerAuditFacet Interface

IServerConfigurationFacet Interface

IServerInformation Interface

IServerPerformanceFacet Interface

IServerSecurityFacet Interface

IServerSelectionFacet Interface

IServerSettings Interface

IServerSetupFacet Interface

ISurfaceAreaFacet Interface

ITableOptions Interface

ITextObject Interface

IUserOptions Interface

IViewOptions Interface

JobScheduleCollectionBase Class

KeyEncryptionType Enumeration

LanguageCollection Class

LinkedServer Class

LinkedServerCollection Class

LinkedServerLogin Class

LinkedServerLoginCollection Class

LinkedTableType Enumeration

LinkFieldType Enumeration

LockEscalationType Enumeration

LockRequestStatus Enumeration

LogFile Class

LogFileCollection Class

Login Class

LoginCollection Class

LoginCreateOptions Enumeration

LoginEvents Class

LoginType Enumeration

LogReuseWaitStatus Enumeration

MappedClassType Enumeration

MasterKey Class

MediaTypes Enumeration

MessageCollectionBase Class

MessageObjectBase Class

MethodLoginType Enumeration

MethodXsdSchemaOption Enumeration

MirroringOption Enumeration

MirroringRole Enumeration

MirroringSafetyLevel Enumeration

MirroringStatus Enumeration

MirroringWitnessStatus Enumeration

MissingObjectException Class

Month Enumeration

NamedSmoObject Class

NSActivationState Enumeration

NumaNodeAffinity Enumeration

NumaNodeCollection Class

NumberedObjectCollectionBase Class

NumberedStoredProcedure Class

NumberedStoredProcedureCollection Class

NumberedStoredProcedureParameter Class

NumberedStoredProcedureParameterCollection Class

ObjectAlteredEventArgs Class

ObjectClass Enumeration

ObjectCreatedEventArgs Class

ObjectDroppedEventArgs Class

ObjectEvent Class

ObjectEventSet Class

ObjectPermission Class

ObjectPermissionInfo Class

ObjectPermissionSet Class

ObjectPermissionSetValue Enumeration

ObjectRenamedEventArgs Class

OleDbProviderSettings Class

OleDbProviderSettingsCollection Class

OnFailureAction Enumeration

OrderColumn Class

OrderColumnCollection Class

PageVerify Enumeration

Parameter Class

ParameterBase Class

ParameterCollectionBase Class

PartitionFunction Class

PartitionFunctionCollection Class

PartitionFunctionEvents Class

PartitionFunctionParameter Class

PartitionFunctionParameterCollection Class

PartitionNumberedObjectCollectionBase Class

PartitionScheme Class

PartitionSchemeCollection Class

PartitionSchemeEvents Class

PartitionSchemeParameter Class

PartitionSchemeParameterCollection Class

Payload Class

PercentCompleteEventArgs Class

PercentCompleteEventHandler Delegate

PerfMonMode Enumeration

PerformanceCounters Class

PermissionInfo Class

PermissionSetBase Class

PermissionState Enumeration

PhysicalPartition Class

PhysicalPartitionCollection Class

PlanGuide Class

PlanGuideCollection Class

PlanGuideExtender Class

PlanGuideType Enumeration

PrincipalType Enumeration

PrivateKeyEncryptionType Enumeration

PrivilegeTypes Enumeration

ProgressReportEventArgs Class

ProgressReportEventHandler Delegate

PropertyCannotBeRetrievedException Class

PropertyCollection Class

PropertyNotSetException Class

PropertyReadOnlyException Class

PropertyTypeMismatchException Class

PropertyWriteException Class

ProtocolType Enumeration

ProviderAuthenticationType Enumeration

RangeType Enumeration

RecoveryModel Enumeration

RelocateFile Class

RepairOptions Enumeration

RepairStructure Enumeration

RepairType Enumeration

ReplicationOptions Enumeration

ResourceGovernor Class

ResourcePool Class

ResourcePoolCollection Class

ResourceUsage Enumeration

Restore Class

RestoreActionType Enumeration

RestoreType Enumeration

ResultFormat Enumeration

RetentionPeriodUnits Enumeration

RoleTypes Enumeration

Rule Class

RuleCollection Class

Schema Class

SchemaCollection Class

SchemaCollectionBase Class

SchemaCustomResolver Class

SchemaEvents Class

ScriptingErrorEventArgs Class

ScriptingErrorEventHandler Delegate

ScriptingFilter Delegate

ScriptingOptions Class

ScriptNameObjectBase Class

ScriptOption Class

ScriptSchemaObjectBase Class

SecondaryXmlIndexType Enumeration

Server Class

ServerActiveDirectory Class

ServerAdapter Class

ServerAdapterBase Class

ServerAuditSpecification Class

ServerAuditSpecificationCollection Class

ServerAuditSpecificationExtender Class

ServerConfigurationAdapter Class

ServerDdlTrigger Class

ServerDdlTriggerCollection Class

ServerDdlTriggerEvent Class

ServerDdlTriggerEventSet Class

ServerDdlTriggerExecutionContext Enumeration

ServerEvent Class

ServerEventArgs Class

ServerEventHandler Delegate

ServerEvents Class

ServerEventSet Class

ServerLoginMode Enumeration

ServerMirroringRole Enumeration

ServerPermission Class

ServerPermissionInfo Class

ServerPermissionSet Class

ServerPermissionSetValue Enumeration

ServerProxyAccount Class

ServerRole Class

ServerRoleCollection Class

ServerSecurityAdapter Class

ServerSelectionAdapter Class

ServerSetupAdapter Class

ServerStatus Enumeration

ServerSurfaceAreaAdapter Class

ServerTraceEvent Class

ServerTraceEventSet Class

ServiceBrokerPayload Class

ServiceMasterKey Class

ServiceQueueEvent Class

ServiceQueueEventSet Class

ServiceRequestException Class

ServiceStartMode Enumeration

SfcDependencyException Class

ShrinkMethod Enumeration

SimpleObjectCollectionBase Class

SmoApplication Class

SmoApplication.AnyObjectEventHandler Delegate

SmoApplication.DatabaseEventHandler Delegate

SmoApplication.ObjectAlteredEventHandler Delegate

SmoApplication.ObjectCreatedEventHandler Delegate

SmoApplication.ObjectDroppedEventHandler Delegate

SmoApplication.ObjectRenamedEventHandler Delegate

SmoCollectionBase Class

SmoDmfAdapter Class

SmoEventArgs Class

SmoException Class

SmoExceptionType Enumeration

SmoObjectBase Class

SmoObjectExtender(T) Class

SnapshotIsolationState Enumeration

SoapMethodCollectionBase Class

SoapMethodObject Class

SoapPayload Class

SoapPayloadMethod Class

SoapPayloadMethodCollection Class

SortedListCollectionBase Class

SortOrder Enumeration

SpatialGeoLevelSize Enumeration

SpatialIndexType Enumeration

SqlAssembly Class

SqlAssemblyCollection Class

SqlAssemblyEvent Class

SqlAssemblyEvents Class

SqlAssemblyEventSet Class

SqlAssemblyFile Class

SqlAssemblyFileCollection Class

SqlDataType Enumeration

SqlPropertyCollection Class

SqlPropertyInfo Class

SqlServerRegistrations Class

SqlServerVersion Enumeration

SqlServerVersions Enumeration

SqlSmoObject Class

SqlSmoState Enumeration

SqlVerifyAction Enumeration

Statistic Class

StatisticCollection Class

StatisticColumn Class

StatisticColumnCollection Class

StatisticEvents Class

StatisticsScanType Enumeration

StatisticsTarget Enumeration

StopListOption Enumeration

StoredProcedure Class

StoredProcedureCollection Class

StoredProcedureEvent Class

StoredProcedureEvents Class

StoredProcedureEventSet Class

StoredProcedureParameter Class

StoredProcedureParameterCollection Class

SymmetricKey Class

SymmetricKeyCollection Class

SymmetricKeyEncryption Class

SymmetricKeyEncryptionAlgorithm Enumeration

SymmetricKeyEncryptionType Enumeration

Synonym Class

SynonymBaseType Enumeration

SynonymCollection Class

SynonymEvents Class

SystemDataType Class

SystemDataTypeCollection Class

SystemMessage Class

SystemMessageCollection Class

Table Class

TableCollection Class

TableEvent Class

TableEvents Class

TableEventSet Class

TableViewBase Class

TableViewTableTypeBase Class

TcpProtocol Class

TerminationClause Enumeration

TransactionTypes Enumeration

Trigger Class

TriggerCollection Class

TriggerEvents Class

UnknownPropertyException Class

UnsupportedEngineTypeException Class

UnsupportedFeatureException Class

UnsupportedObjectNameException Class

UnsupportedVersionException Class

UrnCollection Class

UrnIdOption Enumeration

User Class

UserCollection Class

UserDefinedAggregate Class

UserDefinedAggregateCollection Class

UserDefinedAggregateParameter Class

UserDefinedAggregateParameterCollection Class

UserDefinedDataType Class

UserDefinedDataTypeCollection Class

UserDefinedDataTypeResolver Class

UserDefinedFunction Class

UserDefinedFunctionCollection Class

UserDefinedFunctionEvent Class

UserDefinedFunctionEvents Class

UserDefinedFunctionEventSet Class

UserDefinedFunctionParameter Class

UserDefinedFunctionParameterCollection Class

UserDefinedFunctionType Enumeration

UserDefinedMessage Class

UserDefinedMessageCollection Class

UserDefinedTableType Class

UserDefinedTableTypeCollection Class

UserDefinedTableTypeResolver Class

UserDefinedType Class

UserDefinedTypeCollection Class

UserDefinedTypeEvents Class

UserDefinedTypeFormat Enumeration

UserDefinedTypeResolver Class

UserEvents Class

UserOptions Class

UserType Enumeration

VerifyCompleteEventArgs Class

VerifyCompleteEventHandler Delegate

VersionSerializationAdapter Class

View Class

ViewCollection Class

ViewEvent Class

ViewEvents Class

ViewEventSet Class

WindowsLoginAccessType Enumeration

WorkloadGroup Class

WorkloadGroupCollection Class

WorkloadGroupImportance Enumeration

WrongPropertyValueException Class

WsdlGeneratorOption Enumeration

XmlDocumentConstraint Enumeration

XmlFormatOption Enumeration

XmlSchemaCollection Class

XmlSchemaCollectionCollection Class

XmlTypeDerivation Enumeration

XmlTypeKind Enumeration

XsdSchemaOption Enumeration

Minimize

This topic has not yet been rated - Rate this topic

FragmentationOption Enumeration

SQL Server 2008 R2

The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public enum FragmentationOption

	Member name	Description
	Fast	Value = 1. Calculates statistics based on parent level pages only. This option is available starting with SQL Server 2000.
	Sampled	Value = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005.
	Detailed	Value = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.

The FragmentationOption class are served by the EnumFragmentation method and the GetFragOptionString method.

Reference

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.