When using the 'sp_spaceused' procedure to ascertain the amount of space
used on the SQL Server 7.0 database, as the following formula reaches a
certain figure, eg. 0.565, the 'database size' automatically increases,
thereby bringing the figure down. The formula is:

(Database Size - Unallocated Space) / Database Size

Does anybody know where this figure is held on the system?

Phil Shuttleworth

DBA, IT Services
University of Central England, BIRMINGHAM B42 2SU, UK
Tel: +44(0)121 331 5664 Fax: +44(0)121 356 2875
E-mail: Phil.[Email Address Removed]MS Sql Server LazyDBA home page