Because v6.5 will not auto grow my databases, I have been monitoring the db
sizes then manually growing them as needed. Fortunately I only need to grow
a few db's once per month or so.
I am investigating methods of automating the process of determining space
left in the databases. By viewing the db properties in the Enterprise
Manager, a db might show 50 meg free. When I use a sp_spaceused command in
Query Analyzer, I see the unallocated space and unused columns. Both these
columns values are usually quite different than the amount reported in the
db properties in EM.
Which number should I trust? Is there any other method, including writing a
new stored procedure, that I can use to report the correct number?
Catawba County Government
Newton, North Carolina USA