two undocumented Stored Procedures that allow you to process through all tables in a database, or all databases in a SQL Server instance
http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm