Specifying index type for sp_iqcheckdb [CR 353538]

The new parameter indextype specifies an index type for all of the sp_iqcheckdb modes. The syntax is:

sp_iqcheckdb 'mode target [...] [ resources resource-percent ]'

where

mode: { allocation | check | verify } | repair

target: [ main | local | indextype index-type […] ] database | database resetclocks | { [ indextype index-type ] […] table table-name | index index-name […] }

index-type:: { FP | CMP | LF | HG | HNG | WD| DATE | TIME | DTTM }

Example

Verify the FP and HG indexes in the table t1 and the LF indexes in the table t2.

sp_iqcheckdb 'verify indextype FP indextype HG table t1
indextype LF table t2'