sqldbpool.com
Display the size of all tables in Sql Server 2005
You can use sys.SP_SpaceUsed stored procedure to get the size of all the tables. Below query will calulate the space of all the tables. –create temp table to store the result CREATE TABLE #te…