Database.CheckTablesDataOnly Method

Definition

Overloads

CheckTablesDataOnly(RepairStructure)

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair structure

CheckTablesDataOnly(RepairOptions, RepairStructure, Nullable<Int64>)

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options and repair structure.

CheckTablesDataOnly()

Invokes DBCC CHECKDB with the NOINDEX option

CheckTablesDataOnly(RepairOptions)

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options

CheckTablesDataOnly(RepairStructure)

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair structure

public System.Collections.Specialized.StringCollection CheckTablesDataOnly (Microsoft.SqlServer.Management.Smo.RepairStructure repairStructure);
member this.CheckTablesDataOnly : Microsoft.SqlServer.Management.Smo.RepairStructure -> System.Collections.Specialized.StringCollection
Public Function CheckTablesDataOnly (repairStructure As RepairStructure) As StringCollection

Parameters

repairStructure
RepairStructure

Returns

StringCollection

Messages generated by DBCC CHECKDB

CheckTablesDataOnly(RepairOptions, RepairStructure, Nullable<Int64>)

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options and repair structure.

public System.Collections.Specialized.StringCollection CheckTablesDataOnly (Microsoft.SqlServer.Management.Smo.RepairOptions repairOptions, Microsoft.SqlServer.Management.Smo.RepairStructure repairStructure, long? maxDOP = default);
member this.CheckTablesDataOnly : Microsoft.SqlServer.Management.Smo.RepairOptions * Microsoft.SqlServer.Management.Smo.RepairStructure * Nullable<int64> -> System.Collections.Specialized.StringCollection
Public Function CheckTablesDataOnly (repairOptions As RepairOptions, repairStructure As RepairStructure, Optional maxDOP As Nullable(Of Long) = null) As StringCollection

Parameters

repairOptions
RepairOptions
repairStructure
RepairStructure
maxDOP
Nullable<Int64>

Degree of parallelism to allow for the check. Only valid for sql version >= 13

Returns

StringCollection

Messages generated by DBCC CHECKDB

CheckTablesDataOnly()

Invokes DBCC CHECKDB with the NOINDEX option

public System.Collections.Specialized.StringCollection CheckTablesDataOnly ();
member this.CheckTablesDataOnly : unit -> System.Collections.Specialized.StringCollection
Public Function CheckTablesDataOnly () As StringCollection

Returns

StringCollection

Messages generated by DBCC CHECKDB

CheckTablesDataOnly(RepairOptions)

Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options

public System.Collections.Specialized.StringCollection CheckTablesDataOnly (Microsoft.SqlServer.Management.Smo.RepairOptions repairOptions);
member this.CheckTablesDataOnly : Microsoft.SqlServer.Management.Smo.RepairOptions -> System.Collections.Specialized.StringCollection
Public Function CheckTablesDataOnly (repairOptions As RepairOptions) As StringCollection

Parameters

repairOptions
RepairOptions

Returns

StringCollection

Messages generated by DBCC CHECKDB

Applies to