Negative Unallocated Space?

Can anyone tell me what the heck negative unallocated space means?
We have server 6.5, and there is obviously plenty of room in our 4+ gb DB,
but shen I run an sp_space used I get
the following confusion:
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
database_name database_size unallocated space
-- -- --
MainDB 4358.00 MB -1065.14 MB
reserved data index_size unused
-- -- -- --
5553300 KB 4866524 KB 677366 KB 9410 KB
Anyone know what to do here?
Thansk.
Charles...Try DBCC updateusage('dbname') . Not too sure if that was a valid command
then in 6.5. Give that a try and then run your stored procedure again
"Charles Viescas" <cviescas@.yahoo.com> wrote in message
news:O4vtwI0iDHA.2076@.TK2MSFTNGP09.phx.gbl...
> Can anyone tell me what the heck negative unallocated space means?
> We have server 6.5, and there is obviously plenty of room in our 4+ gb DB,
> but shen I run an sp_space used I get
> the following confusion:
> DBCC execution completed. If DBCC printed error messages, see your System
> Administrator.
> database_name database_size unallocated space
> -- -- --
> MainDB 4358.00 MB -1065.14 MB
> reserved data index_size unused
> -- -- -- --
-
> 5553300 KB 4866524 KB 677366 KB 9410 KB
>
> Anyone know what to do here?
> Thansk.
> Charles...
>|||Charles
Try the following in isql
dbcc checktable (syslogs)
checkpoint
Hope this helps
John|||Hey, thanks guys! I tried both, DBCC UpdateUsage and the CheckTable, and it
found a problem in the syslogs.
Now, it looks a little better. (I still dont' like the minus, but it it
moved and I am not as wworried about it. How in the heck do I get an unused
of Negative that is larger than the DB ? :-) )
database_name database_size unallocated space
-- -- --
MainDB 4358.00 MB 3204.87 MB
reserved data index_size unused
-- -- -- --
1180804 KB 494022 KB 5049868 KB -4363086 KB
Thanks!!
Charles...
"John Bandettini" <johnbandettini@.nochance.com> wrote in message
news:22d6101c38bf7$64055580$a601280a@.phx.gbl...
> Charles
> Try the following in isql
> dbcc checktable (syslogs)
> checkpoint
> Hope this helps
> John