CheckTables Method
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The CheckTables method tests the integrity of database pages implementing storage for all tables and indexes defined on the tables of the referenced database.
구문
object
.CheckTables( [ RepairType ] )as String
Parts
object
Expression that evaluates to an object in the Applies To list.RepairType
Optionally specifies a database repair action.
Prototype (C/C++)
HRESULT CheckTables(SQLDMO_LPBSTR pResult
SQLDMO_DBCC_REPAIR_TYPE lType = SQLDMORepair_None);
Returns
A string that contains detailed status and error information. For errors with severity 11 or greater, the string is returned as a trappable error in the Err object in Visual Basic.
주의
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 CheckTables method to perform database repair. To set single-user mode on a database using SQL-DMO, use the SingleUser property of the DBOption object.
The CheckTables method is implemented using the Transact-SQL DBCC CHECKDB statement. The return value of the CheckTables method is a string representation of the error messages returned by DBCC CHECKDB.
[!참고]
SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.