sp_tab_suspectptn

Description

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.

Syntax

sp_tab_suspectptn [table_name]

Parameters

table_name

is the name of the table containing suspect partitions.

Usage

If you:

Permissions

Any user can use sp_tab_suspectptn.

See also

Stored procedures sp_indsuspect