Compartilhar via

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

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

Applies to

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()

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