>>While researching an answer to your question I stambled upon this very interesting artcile
>>
>>http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx
>
>Thanks, there's a lot of interesting topics in there.

In addition, see this
http://www.developer.com/db/print.php/3622881

So, I guess you would use
sp_MSForEachTable in conjunction with

http://www.databasejournal.com/features/mssql/article.php/3441031

sp_helpstats procedure.

A bit tired right now to write the statement, but hopefully you'll make it and post the final solution.