Microsoft KB Archive/247490

= BUG: Enterprise Manager May Incorrectly Calculate Index Size =

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.