SQL Server View SQL statement for data table footprint

1 Declare @name varchar( +)2 Declare @sql varchar( +)3 4 if object_id('tempdb: #space') is  not NULL Drop Table#Space5 Create Table#Space(Namevarchar( -), Rowsbigint, reservedvarchar( A), datavarchar( A), index_sizevarchar( A), unusedvarchar( A))6 7 DeclareSpcursorLocal for Select '['+Name+']'  fromsysobjectswhereType= 'u'8 OpenSP9 FetchSp into @nameTen  while @ @fetch_status = 0 One begin A Set @sql = 'INSERT INTO #space exec sp_spaceused' + @name - exec(@sql) - FetchSp into @name the End - CloseSP -  - Select *  from#Space Order  by cast(Replace(Reserved,'KB',"') as int)desc

From: SQL Server Technology product Group (250942633) group Friends

I independent blog: http://www.haoyuncn.net/sql-server-space

SQL Server View SQL statement for data table footprint