exec sp_spaceused reporting negative values???

[will2]

Table size reported by the SQL 7.0 Enterprise manager is 1,716 mb

There are four indexes on this table

Index 1 - Clustered - 2 columns
Index 2 - 201mb - 4 columns
Index 3 - 162mb - 5 columns
Index 4 - 707mb - 1 column

exec sp_spaceused 'INSIGHT..CTEEXC'

name rows reserved data index_size unused
-------------------- ----------- ------------------ ------------------ ------------------ ------------------
CTEEXC 5055246 1592400 KB 1685112 KB -89208 KB -3504 KB


Why are there negative values in the index_size and unused columns?

 

[tlbroadbent]

Usually, running sp_spaceused with the updateusage option on will correct this problem. The erroneous results are due to inaccuracies in the sysindexes table.

sp_spaceused 'objname', 'updateusage'

You can also update usage with DBCC UPDATEUSAGE. See details in SQL BOL. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.