sql reporting no space available

[jas81864]

When right clicking on several of our databases and choosing properties the value "space available" shows 0.00. When the data file and drive have tons of space. This is affecting a third party tool we use to monitor the databases resulting in a lot of incorrect warnings going out. Does anyone know how to "adjust" sql to report the correct space available?

[MAK]

Is it SQL 6.5?

[MAK]

try "sp_spaceused" on a database and see what it shows.

if it shows in negative then you have to run

"dbcc updateusage" - Reports and corrects inaccuracies in the sysindexes table

[jas81864]

No, all of the effected servers are 2000 with sp3. I have seen the same thing on 5 or 6 servers with multiple databases effected on each. The databases are set to unrestricted growth, show 200 - 2000 mb free. The drives have several gigs free.

[MAK]

It will expand automatically. it is just space available on the allocated on the .mdf and .ldf file.

[jas81864]

Thanks this worked!

[rmiao]

Another way is 'sp_spaceused @updateusage = true'.