Database space used

EXECUTE sp_spaceused ur_table; EXECUTE sp_MSforeachtable 'EXECUTE sp_spaceused [?];';