Call sp_spaceused.

If the size of a table is needed, use it with a table name: sp_spaceused table_name.