Mark,

I'm getting a negative free_DB_Space for two of our databases. When running these two queries:   select size, maxsize 'maxsize' from sysfiles where (status & 64 = 0) compute sum(size)

select sum(reserved) 'totalreserved'  from [sysindexes] where indid in (0, 1, 255) I get

size        maxsize    

----------- -----------

319872      -1

9600000     -1

109120      -1

9487992     -1

===========

19516984

totalreserved

-------------

20830649

So the sum from sysindexes is bigger than sysfiles. Is this because we're using filegroups on these databases?

TIA

Henrik Staun Poulsen, Denmark