This topic has not yet been rated - Rate this topic

CheckTableDataOnly Method

SQL Server 2008 R2

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The CheckTableDataOnly method tests the integrity of database pages implementing storage for the referenced table.

Syntax


object
.CheckTableDataOnly( )
as String

Parts

object: Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT CheckTableDataOnly(
SQLDMO_LPBSTR pResult);

Note
SQL Distributed Management Objects (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.

Returns

A string that contains error detail information.

Remarks

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

Applies to:

Table Object

Reference

DBCC CHECKTABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD