Negative reserved size

My turn to ask a question.

Running sp_spaceused on one of my tables yields a negative reserved size (-96 kb), and a corresponding negative unused size.

The table has only 7 fields, all varchar, datetime, or int. No indexes or foreign keys. Under 2000 rows.

I'm running 2000 with patches.

Anybody see this before? I couldn't find anything about this on Microsoft's support site.

blindmanIf you run

sp_spaceused tablename, true

does the value change? the true forces sysindexes to be updated and reflected in what's returned.|||Thanks. That did it. I was not aware of that sp_spaceused parameter.

Apparently, the sp_spaceused parameter defaults to "False"!

blindman|||Yes it does, it really jsut runs a DBCC updateusage (I believe only against the table, it might be the database though) THat updates your sysindexes which is what spaceused relies on.

Don't know how you got negative values in reserved though, I tried making it by doing bulk inserts into an new empty table but it gave me O for reserved until I ran the updateusage.