CheckTablesDataOnly Method
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The CheckTablesDataOnly method tests the integrity of database pages implementing storage for all tables in the referenced database.
Syntaxe
object.CheckTablesDataOnly( )as String
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT CheckTablesDataOnly(
SQLDMO_LPBSTR pResult);
[!REMARQUE]
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.
Notes
The CheckTablesDataOnly method is implemented 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.