Displaying Database and Transaction Log Space

Microsoft® SQL Server™ can display the number of rows, reserved disk space, and disk space used by a table in a database. It 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 you have in your database, whether the database will have to be expanded (if autogrow is not permitted), and how fast your database is growing (if you maintain a history of the data space that is used).

To display data space information for a database

To display log space information for a database