Compartir a través de


RepairOptions Enumeración

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

Esta enumeración tiene un atributo FlagsAttribute que permite una combinación bit a bit de los valores de sus miembros.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.SqlEnum (en Microsoft.SqlServer.SqlEnum.dll)

Sintaxis

'Declaración
<FlagsAttribute> _
Public Enumeration RepairOptions
'Uso
Dim instance As RepairOptions
[FlagsAttribute]
public enum RepairOptions
[FlagsAttribute]
public enum class RepairOptions
[<FlagsAttribute>]
type RepairOptions
public enum RepairOptions

Miembros

Nombre del miembro Descripción
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
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.