Found this very handy:
sp_msforeachtable 'sp_spaceused "?"'
Produces a kind of ugly output (returns a table for each table). The original article includes a query to get all the results into one table: Quick way to find space used by each table in a database
Post a Comment