How To Obtain The Size Of All Tables In A SQL Server Database

Search the XGlobe knowledge Base:

How to know the space used by each table without using Management Studio's table properties.

SQL Server gives you everything you need with its Stored Procedure sp_spaceused. Unfortunately this SP does not support iterating over all tables in a database, so we needed to leverage another (undocumented) Stored Procedure sp_msForEachTable.