Printable View
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?
Is it SQL 6.5?
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
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.
It will expand automatically. it is just space available on the allocated on the .mdf and .ldf file.
Thanks this worked!
Another way is 'sp_spaceused @updateusage = true'.