Finding IDs in a database

PerformancePoint uses IDs in the application database which makes for interesting challenges when trying to trace what is going on using SQL Profiler statements.

Here is a script to search databases for a text term which can be easily modified to search for int and bigint data types and use = instead of like clause in the search criteria.

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm