Displays the name of the index. During execution, this column also displays an icon representing the status.
Displays the name of the table or view that the index was created on.
Displays the type of the index: Clustered, Nonclustered, Spatial, or XML.
Displays the status of the disable operation. Possible values after execution are:
Prior to execution Status is blank.
Disabling of the indexes has been started but is not complete.
The disable operation completed successfully.
An error was encountered during the index disable operation, and the operation did not complete successfully.
The disable of the index was not completed successfully because the user stopped the operation.
Provides the text of error messages during the disable operation. During execution, errors appear as hyperlinks. The text of the hyperlinks describes the body of the error. The Message column is rarely wide enough to read the full message text. There are two ways to get the full text:
Move the mouse pointer over the message cell to display a ToolTip with the error text.
Click the hyperlink to display a dialog box displaying the full error.