RepairOptions Enumeration
The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in microsoft.sqlserver.sqlenum.dll)
Syntax
'Bildirim
<FlagsAttribute> _
Public Enumeration RepairOptions
[FlagsAttribute]
public enum RepairOptions
[FlagsAttribute]
public enum class RepairOptions
/** @attribute FlagsAttribute() */
public enum RepairOptions
FlagsAttribute
public enum RepairOptions
Members
| Member name | 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 | |
| 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. |
Remarks
The RepairOptions enumeration class is served by the T:Microsoft.SqlServer.Management.Smo.Database.CheckTables(Microsoft.SqlServer.Management.Smo.RepairOptions) method.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.