Please let me know script or procedure to serach full database for a column value available in all tables.
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.
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.
No one has followed this question yet.