I found this undocumented statement that works real well.

sp_MSForEachTable 'sp_spaceused "?"'

This statement will return a count for each table in your database / catalog.

Make sure that your query view option is set to "text" instead of the "grid" especially if you have a large number of tables.

enjoy

John Esraelo