SQLServerCentral / Discuss content posted by Eric Wahner / Article Discussions / Article Discussions by Author / Space Used By Table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:03:36 GMT20RE: Space Used By Tablehttp://www.sqlservercentral.com/Forums/Topic659976-465-1.aspxAnother way to do it. . .[code]CREATE TABLE #temp ( [name] nvarchar(128), [rows] char(11), [reserved] varchar(18), [data] varchar(18), [index_size] varchar(18), [unused] varchar(18) ) INSERT INTO #temp EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "SELECT [name] AS TableName, CAST([rows] AS int) AS NumOfRows, CAST(REPLACE([reserved],' KB','') AS int) AS [TotalKB]FROM #tempORDER BY 3 DESCSELECT SUM(CAST(REPLACE([reserved],' KB','') AS int)) AS TotalKB_data FROM #tempDROP TABLE #temp[/code]Wed, 04 Mar 2009 05:37:36 GMTWILLIAM MITCHELLSpace Used By Tablehttp://www.sqlservercentral.com/Forums/Topic659976-465-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/sp_spaceused/65923/">Space Used By Table</A>[/B]Wed, 18 Feb 2009 17:23:56 GMTEric Wahner-345205