CheckTablesDataOnly Method (SQL-DMO)

The CheckTablesDataOnly method tests the integrity of database pages implementing storage for all tables in the referenced database.

Applies To

Database Object

Syntax

object.CheckTablesDataOnly() as String

Part Description
object Expression that evaluates to an object in the Applies To list

Returns

A string containing error detail information.

Remarks

The CheckTablesDataOnly method is implemented by using the Transact-SQL DBCC CHECKTABLE statement with the NOINDEX option specified. The return value of the CheckTablesDataOnly method is a string representation of the error messages returned by DBCC CHECKTABLE.

Prototype (C/C++)

HRESULT CheckTablesDataOnly(
SQLDMO_LPBSTR pResult);


Note 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 by using SysFreeString.


See Also

DBCC CHECKTABLE

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.