Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
Cette énumération possède un attribut FlagsAttribute qui permet la combinaison d'opérations de bits de ses valeurs membres.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.SqlEnum (en Microsoft.SqlServer.SqlEnum.dll)
Syntaxe
'Déclaration
<FlagsAttribute> _
Public Enumeration RepairOptions
'Utilisation
Dim instance As RepairOptions
[FlagsAttribute]
public enum RepairOptions
[FlagsAttribute]
public enum class RepairOptions
[<FlagsAttribute>]
type RepairOptions
public enum RepairOptions
Membres
| Nom de membre | Description | |
|---|---|---|
| AllErrorMessages | Displays all reported errors per object. If it is not specified, 200 error messages are displayed for each object. The maximum is 1000. | |
| EstimateOnly | Requests the estimated amount of tempdb space that is required to run the CheckTables method. The actual database check is not performed. | |
| 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. | |
| None | No repair options specified. | |
| TableLock | Limits the checks that are performed. The database catalogs are not checked for consistency, and Service Broker data is not validated. |
Notes
The RepairOptions enumeration class is served by the T:Microsoft.SqlServer.Management.Smo.Database.CheckTables(Microsoft.SqlServer.Management.Smo.RepairOptions) method.