Enumerazione RepairOptions

The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.

Questa enumerazione dispone di un attributo FlagsAttribute che consente una combinazione bit per bit dei relativi valori dei membri.

Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

Sintassi

'Dichiarazione
<FlagsAttribute> _
Public Enumeration RepairOptions
'Utilizzo
Dim instance As RepairOptions

[FlagsAttribute]
public enum RepairOptions

[FlagsAttribute]
public enum class RepairOptions

[<FlagsAttribute>]
type RepairOptions

public enum RepairOptions

	Nome membro	Descrizione
	None	No repair options specified.
	AllErrorMessages	Displays all reported errors per object. If it is not specified, 200 error messages are displayed for each object. The maximum is 1000.
	ExtendedLogicalChecks	Starting with SQL Server 2008, performs logical consistency checks on an indexed view, XML indexes, and spatial indexes.
	NoInformationMessages	Specifies that no information messages will be displayed during the repair operation.
	TableLock	Limits the checks that are performed. The database catalogs are not checked for consistency, and Service Broker data is not validated.
	EstimateOnly	Requests the estimated amount of tempdb space that is required to run the CheckTables method. The actual database check is not performed.