Lists tables with suspect partitions. A range-partitioned table on character-based partition keys can become suspect after a sort-order change, and hash-partitioned tables can become suspect after a cross-platform dump load.
sp_tab_suspectptn [table_name]
is the name of the table containing suspect partitions.
If you:
Provide a table name – Adaptive Server checks only the table named by table_name.
Do not provide a table name – Adaptive Server checks all the tables in the current database.
Any user can execute sp_tab_suspectptn. Permission checks do not differ based on the granular permissions settings.
Stored procedures sp_indsuspect
