Thanks for this I will try those solutions now,

about the question being flawed, not really, but maybe the way I explained what I wanted was. I am counting...

SSC-Addicted

I had the same issue when i was used db mail... after several hours i came across a post that said switch your query around a bit ?

basically...

I find this works well

USE DatabaseName

GO

CREATE TABLE #temp (

table_name sysname ,

row_count INT,

reserved_size VARCHAR(50),

data_size VARCHAR(50),

index_size VARCHAR(50),

unused_size VARCHAR(50))

SET NOCOUNT ON

INSERT #temp

EXEC sp_msforeachtable 'sp_spaceused ''?'''

SELECT a.table_name,

a.row_count,

COUNT(*) AS col_count,

a.data_size

FROM #temp a

INNER JOIN information_schema.columns...