create table #ss (db varchar(50),name varchar(50),rows varchar(50),reserved varchar(50),data varchar(50),index_size varchar(50),unused varchar(50),last_update datetime)
--create table #ss (db varchar(50),name varchar(50),rows varchar(50),reserved varchar(50),data varchar(50),index_size varchar(50),unused varchar(50))
EXEC sp_MSForEachTable 'insert into #ss (name,rows,reserved,data,index_size,unused) EXEC sp_spaceused ''?'', false; '
update #ss set db='crsqlarch.elxmas_pf_arch' where db is null
update #ss set reserved = REPLACE(reserved ,' KB','')
update #ss set data = REPLACE(data ,' KB','')
update #ss set index_size = REPLACE(index_size ,' KB','')
update #ss set last_update =(SELECT max(last_user_update)FROM sys.dm_db_index_usage_stats where database_id = DB_ID () and [OBJECT_ID] =OBJECT_ID(name))
select * from #ss order by convert(int,reserved) desc
drop table #ss