SQL 2005 No Space Avalable

[darronb]

I have a query please.

I have 2 databases, one SQL 2000 and one SQL 2005, When I right click on it and go to properties the is a field labelled "Space Available" and mine is 0.00 Mb.

The system is working fine though.

Also if I click on "Files" my "Autogrowth" column is set to By 20 Mb Unrestricted Growth.

I have 2 questions

1, A brief description of what the "Available Space" field means

2, If it should not be 0.00, what implications will it have and how do you change it.


Thanks for you time

 

[darronb]

OK Guys I have sorted it.

I used "DBCC updateusage ('DBName')