次の方法で共有

CheckTablesWithResult Method

  • [アーティクル]

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The CheckTablesWithResult method executes DBCC CHECKDB WITH TABLERESULTS, and executes CHECKTABLE on all tables.

構文

object
.CheckTablesWithResult( [ RepairType ] )asQueryResults

Parts

  • Object
    Expression that evaluates to an object in the Applies To list.
  • RepairType
    A long integer that specifies database repair action as described in Settings.

Prototype (C/C++)

HRESULT CheckTablesWithResult (
LPSQLDMOQUERYRESULTS * ppResults, 
SQLDMO_DBCC_REPAIR_TYPE lType);

Settings

Set RepairType using these values.

Constant Value Description

SQLDMORepair_Allow_/DataLoss

3

Attempt all database repairs regardless of the possibility of data loss. For example, delete corrupted text objects.

SQLDMORepair_Fast

1

Attempt database repair tasks that do not incur data loss.

SQLDMORepair_None

0

Default. Do not attempt database repair on database inconsistencies encountered.

SQLDMORepair_Rebuild

2

Attempt database repair tasks that do not incur data loss. Rebuild indexes on successful database repair.

Returns

A QueryResults object that contains detailed status and error information in tabular format.

解説

The database referenced by the SQL Distributed Management Objects (SQL-DMO) object must be in single-user mode when using the RepairType argument of the CheckTablesWithResult method to perform database repair. To set single-user mode on a database using SQL-DMO, use the SingleUser property of the DBOption object.

CheckTablesWithResult is implemented using the Transact-SQL DBCC CHECKDB WITH TABLERESULTS statement, and differs from the CheckTables method in that results are returned in tabular format.

It is recommended that you use the properties and methods of the QueryResults object to retrieve information from the result set.

If no repair action is specified, RepairType defaults to SQLDMORepair_None.

ms135645.note(ja-jp,SQL.90).gifメモ :
If an application calls CheckTablesWithResult on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.

Applies to:

Database2 Object