Article ID: 247490
Article Last Modified on 9/4/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q247490
BUG #: 56896 (SQLBUG_70)
SYMPTOMS
When you click a database within the SQL Enterprise Manager (SEM), and then you select Table Indexes in the right pane, the index size that displays may be incorrect for non-clustered indexes.
WORKAROUND
You can use the stored procedure sp_spaceused to obtain the total space used by the indexes. There is not a supported way to calculate the space used by each index.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
Additional query words: usage mmc gui
Keywords: kbbug kbpending KB247490