sp_spaceused provides:
A summary of space used in the database
A summary of space used by a table and its indexes and text/image storage
A summary of space used by a table, with separate information on indexes and text/image storage.