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.

NoteNote

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

ADD
Show:
© 2014 Microsoft