Getting the Size/Space of ALL TABLES in the Current
Database
List the space used in all
tables within the currently connected database.
It takes all the tables from
the currently connected database and displays the size of the table in the
result window.
exec sp_msforeachtable "sp_spaceused
'?'"
Just drop the query
and run it. J