Database.CheckTablesDataOnly Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Smo

Assembly:: Microsoft.SqlServer.Smo.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Overloads

CheckTablesDataOnly(RepairOptions, RepairStructure, Nullable<Int64>)	Invokes DBCC CHECKDB with the NO_INDEX option and the given repair options and repair structure.
CheckTablesDataOnly(RepairStructure)	Invokes DBCC CHECKDB with the NO_INDEX option and the given 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(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) = Nothing) 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

Applies to

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

Applies to

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

Applies to

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