I have written a short article regarding this.
Please check my blog and provide me your valuable feedback.
http://venkattechnicalblog.blogspot.com/2008/09/list-out-all-tables-and-row-count-in.html
Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:
http://venkattechnicalblog.blogspot.com/