Export (0) Print
Expand All

Index.CheckIndexWithResult Method

Tests the integrity of database pages that store the index.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public DataTable CheckIndexWithResult()

Return Value

Type: DataTable
A DataTable object value that contains the error message generated by the integrity check.

The CheckIndex method is implemented using the Transact-SQL DBCC CHECKTABLE WITH TABLERESULTS statement.


Indexes based on the UserDefinedTableType object cannot be checked and running this method will generate an exception.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft