共用方式為


RepairOptions 列舉

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

此列舉有一個允許其成員值為位元組合的 FlagsAttribute 屬性。

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.SqlEnum (在 Microsoft.SqlServer.SqlEnum.dll 中)

語法

'宣告
<FlagsAttribute> _
Public Enumeration RepairOptions
'用途
Dim instance As RepairOptions
[FlagsAttribute]
public enum RepairOptions
[FlagsAttribute]
public enum class RepairOptions
[<FlagsAttribute>]
type RepairOptions
public enum RepairOptions

成員

成員名稱 說明
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.

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間