Using SCOME and sys.dm_db_index_physical_stats (2005 only), sys.Object, sys.Indexes and sys.Partitions, you can...

Analyse Index fragmentation in real time on any database on any linked SQL Server. Optionally specify the minimum amount of fragmentation to report on. Columns returned are as follows. Database Name, Table Name, Index Name, Type (Clustered, Heap etc), Fill Factor, Table Row Count, Avg Fragmentation, Page Count, Is Primary Key.

This help guide can be hidden by clicking the minimise icon on the right.