The Open Source U

A couple of great blog articles on sp_msForEachTable. This is an undocumented stored procedure.

http://www.shanedevane.net/msforeachtable
http://blog.sqlauthority.com/2007/01/31/sql-server-reindexing-database-tables-and-update-statistics-on-tables/

http://stackoverflow.com/questions/977400/undocumented-system-procedure-spmsforeachtable-and-the-whereand-parameter