• Yep.. had q quick look. I'd recommand dynamic sql - use a while loop to work through your objects to pull stats back from.

    create table #nextobject (record varchar(200))

    Within the loop:

    exec master..xp_cmdshell 'osql -d yourdatabase -q "dbcc show_statistics(yourtable,''yourindex'')" -o c:\sqltempout.txt -E'

    bulk insert #entirefile from 'c:\sqltempout.txt' with (rowterminator = '')

    Now all you need to do is locate the relevant line which should be simple enough with a patindex etc.

    Have fun.