Displaying Database and Transaction Log Space

Microsoft® SQL Server™ 2000 can display the number of rows, reserved disk space, and disk space used by a table in a database. SQL Server can also display the reserved disk space that is used by an entire database as well as statistics about the use of transaction log space in a database. This indicates how much data is in the database, whether the database must be expanded (if autogrow is not permitted), and how fast the database is growing (if you maintain a history of the data space that is used).

To display data space information for a database

Transact-SQL