alltable spaceused

create table ##check_alldatabase_sp_spaceused (
    dbname nvarchar(128),
    [name] nvarchar(128),
    [rows] char(11),
    reserved_inKB varchar(18),
    data_inKB varchar(18),
    index_size_inKB varchar(18),
    unused_inKB varchar(18)
)

if (CONVERT(varbinary,@@microsoftversion) > 0x09000000)
begin
exec sp_MSforeachdb @replacechar = '*', @command1 = '
use [*]
if ''*'' not in (''tempdb'')
begin
    create table ##result (
        [name] nvarchar(128),
        [rows] char(11),
        reserved varchar(18),
        data varchar(18),
        index_size varchar(18),
        unused varchar(18)
    )
    exec sp_MSforeachtable @command1 = ''insert ##result exec sp_spaceused [?]''
    insert into ##check_alldatabase_sp_spaceused
    select
        db_name(),
        [name],
        [rows],
        replace(reserved,'' KB'',''''),
        replace(data,'' KB'',''''),
        replace(index_size,'' KB'',''''),
        replace(unused,'' KB'','''')
    from
        ##result
    drop table ##result
end
'
end
else
begin
    declare @@name varchar(128)
    declare @@cmd varchar(2000)
    declare cur cursor forward_only for select name from master.dbo.sysdatabases with(nolock)
    open cur
    fetch next from cur into @@name
    while @@fetch_status = 0
    begin
        if @@name not in ('tempdb')
        begin
        set @@cmd = 'use ['+@@name+']
        create table ##result (
            [name] nvarchar(128),
            [rows] char(11),
            reserved varchar(18),
            data varchar(18),
            index_size varchar(18),
            unused varchar(18)
        )
        exec sp_MSforeachtable @command1 = ''insert ##result exec sp_spaceused [?]''
        insert into ##check_alldatabase_sp_spaceused
        select
            db_name(),
            [name],
            [rows],
            replace(reserved,'' KB'',''''),
            replace(data,'' KB'',''''),
            replace(index_size,'' KB'',''''),
            replace(unused,'' KB'','''')
        from
            ##result
        drop table ##result
        '
        exec (@@cmd)
        end
        fetch next from cur into @@name
    end
    close cur
    deallocate cur
end

select * from ##check_alldatabase_sp_spaceused

drop table ##check_alldatabase_sp_spaceused