You may want to look at http://www.sqlservercentral.com/articles/Search/64877/ It is an article I wrote some time ago that addresses this topic.
answered May 14 '10 at 12:35 PM
Sorry for confusion..... Thanks for ur answers....
Im looking for a script or procedure for physical values serach.......
John u rite.....im looking for physical values serach.......
eg the word "apple" in any text column from all tables available in a database.
answered May 15 '10 at 05:17 AM