Friday, June 1, 2012

Get data size of all tables in Sql server database

CREATE
TABLE #temp (    
[table_name] NVARCHAR(128),  
[rows] CHAR(11),   
reserved VARCHAR(18),    
data VARCHAR(18),    
index_size VARCHAR(18),   
unused VARCHAR(18))

INSERT #temp EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''