This is what I use, however it would need to be modified to insert into a table if you wanted to select against it.

sp_msforeachdb 'use ?;exec sp_spaceused'

cheers,

Andrew