Using SQL Server Management Studio 2008, right-click on your database, select Reports then Standard Reports then choose Index Physical Statistics. This report will show fragmentation details for all ...

Does someone have a query off hand that provides the fragmentation level of all indexes within a database? I have one that targets a table -- but there are too many tables.