April 4, 2008 at 1:26 pm
Is there a script or query available to search all the tables in a particular database for a specifc piece of data. We have a huge database and Im looking for an email address that constantly pops up in our application but we cant find it anywhere in the main tables. We have too many tables to go thru one by one. IS there a way to search all the tables for a piece of data?
April 4, 2008 at 2:04 pm
This link should help. It does exactly what you are asking for.
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
April 4, 2008 at 2:10 pm
wow that was fast, thank you, I did it already, I put the msdb db in single user mode and it applied right away.
Thank you.
April 4, 2008 at 2:12 pm
sorry, wrong forum thread
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply