Getting Information about Database Storage

The sp_helpdb and sp_spaceused system procedure help determine which database devices are currently allocated to databases and how much space each database uses.