Something I threw together in a rush for another query (had a few mins to kill). If you're on 2000 and run low on options you could always modify it...

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...

He was after show_statistics, not contig. These list two very different results sets. Key difference here: Statistics returns multiple tables as part of it's results set. Contig returns only one....