CheckCatalogWithResult Method

SQL-DMO

SQL-DMO

CheckCatalogWithResult Method

The method CheckCatalogWithResult tests the integrity of the catalog of the referenced database.

Applies To
Database2 Object
Syntax

object.CheckCatalogWithResult( ) as QueryResults

Parts

object

Expression that evaluates to an object in the Applies To list

Prototype (C/C++)

HRESULT CheckCatalogWithResult(
LPSQLDMOQUERYRESULTS * ppResults);

Returns

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

Remarks

CheckCatalogWithResult is implemented using the Transact-SQL DBCC CHECKCATALOG WITH TABLERESULTS statement, and differs from the CheckCatalog 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.

Note  If an application calls CheckCatalogWithResult 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.