![sp_iqversionuse procedure added [CR 401646]](arrow-right.gif){kind=icon}
The sp_iqcheckdb system stored procedure was enhanced in ESD #4.4 so that allocation mode now displays indexes that are inconsistent due to multiply-owned blocks.
The following keywords print block numbers for affected database blocks to the IQ message file:
dumpleaks — leaked blocks
dumpdups — duplicate blocks
dumpunallocs — unallocated blocks
For example, the following performs allocation checking for the entire database and reports block numbers for any leaked blocks:
sp_iqcheckdb 'allocation database dumpleaks'
