dbcc_showcontig

create table #dbcc_showcontig (
        ObjectName      sysname,
        ObjectId        int,
        IndexName       sysname,
        IndexId         smallint,
        Level           smallint,
        Pages           int,
        Rows            int,
        MinimumRecordSize       int,
        MaximumRecordSize       int,
        AverageRecordSize       float,
        ForwardedRecords        int,
        Extents int,
        ExtentSwitches  int,
        AverageFreeBytes        float,
        AveragePageDensity      float,
        ScanDensity     float,
        BestCount       int,
        ActualCount     int,
        LogicalFragmentation    int,
        ExtentFragmentation     int
)

select * into #showcontig_summary from #dbcc_showcontig
alter table #showcontig_summary add dbname sysname

exec sp_MSforeachdb @command1 = '
    print ''?''
    use ?
    insert into #dbcc_showcontig exec(''dbcc showcontig with tableresults, all_indexes'')
    insert into #showcontig_summary select *, db_name() as dbname from #dbcc_showcontig
    truncate table #dbcc_showcontig
'

select * from #showcontig_summary

drop table #dbcc_showcontig
drop table #showcontig_summary