This works for me:

create table #TableSize (database_name varchar(150),

id int,

table_schema varchar(150),

table_name varchar(150),

num_rows int,

reserved varchar(150),

data varchar(150),

index_size varchar(150),

unused varchar(150)

)

INSERT INTO #TableSize

EXECUTE OVER_SET '

SELECT "{db}" As DB

, tbl.object_id As Tbl_ID

, sch.Name As [Schema]

, tbl.Name

, Coalesce( (Select sum (spart.rows) from sys.partitions spart

Where spart.object_id = tbl.object_id and spart.index_id < 2), 0) AS [RowCount]

, Coalesce( (Select Cast(v.low/1024.0 as float)

* SUM(a.total_pages)

FROM sys.indexes as i

JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id

JOIN sys.allocation_units as a ON a.container_id = p.partition_id

Where i.object_id = tbl.object_id )

, 0.0) AS [ReservedKB]

, Coalesce( (Select Cast(v.low/1024.0 as float)

* SUM(CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END)

FROM sys.indexes as i

JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id

JOIN sys.allocation_units as a ON a.container_id = p.partition_id

Where i.object_id = tbl.object_id)

, 0.0) AS [DataKB]

, Coalesce( (Select Cast(v.low/1024.0 as float)

* SUM(a.used_pages - CASE WHEN a.type <> 1 THEN a.used_pages WHEN p.index_id < 2 THEN a.data_pages ELSE 0 END)

FROM sys.indexes as i

JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id

JOIN sys.allocation_units as a ON a.container_id = p.partition_id

Where i.object_id = tbl.object_id )

, 0.0) AS [IndexKB]

, Coalesce( (Select Cast(v.low/1024.0 as float)

* SUM(a.total_pages - a.used_pages)

FROM sys.indexes as i

JOIN sys.partitions as p ON p.object_id = i.object_id and p.index_id = i.index_id

JOIN sys.allocation_units as a ON a.container_id = p.partition_id

Where i.object_id = tbl.object_id )

, 0.0) AS [UnusedKB]

FROM [{db}].sys.tables AS tbl

INNER JOIN [{db}].sys.schemas As sch ON sch.schema_id = tbl.schema_id

INNER JOIN [{db}].sys.indexes AS idx ON (idx.object_id = tbl.object_id and idx.index_id < 2)

INNER JOIN master.dbo.spt_values v ON (v.number=1 and v.type="E")

',

@from = 'sys.sysdatabases WHERE dbid > 4',

@subs1 = '{db}=name',

@quote = '"'

;

SELECT * from #TableSize ;

DROP table #TableSize ;