TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

RepairOptions Enumeration

 

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

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

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

[FlagsAttribute]
public enum class RepairOptions

Member nameDescription
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.

The RepairOptions enumeration class is served by the T:Microsoft.SqlServer.Management.Smo.Database.CheckTables(Microsoft.SqlServer.Management.Smo.RepairOptions) method.

Return to top
Show:
© 2016 Microsoft