• It will work for SQL 2005 as well if we change

    Select db_name()

    ,object_name(s.object_id) As ObjectName

    --,object_schema_name(s.object_id) As SchemaName-- 2008

    ,object_name(s.object_id) As SchemaName -- 2005

    ,i.Name As IndexName

    ,s.avg_fragmentation_in_percent

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005