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.

• Checking Space Used in a Database
  To get a summary of the amount of storage space used by a database, execute sp_spaceused in the database.
• Checking Summary Information for a Table
  Issue sp_spaceused with a table name to view information about a specific table.
• Checking Information for a Table and Its Indexes
  Include the parameter 1 (one) and the table name to view information about the space used by individual indexes.