Getting Information About Databases

To get a report on a database, execute sp_helpdb; for a report on the space used in a database, use sp_spaceused.