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.

• Using sp_helpdb to Find Database Device Names and Options
  Use sp_helpdb with the database name to find the names of the database devices on which a particular database resides.
• Checking the Amount of Space Used
  sp_spaceused provides a summary of space use, in the database, and by tables with indexes and text and image storage.
• Querying System Table for Space Usage Information
  You may want to write some of your own queries to get information about physical storage.