Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-06-23 : 12:04:55
|
| Hi,I saw recently someone write a query to search through all the tables and name them, which ones held a certain word or phrase he typed.So list all the tables that held the word 'technology' in the database, any ideas anyone? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-23 : 12:10:10
|
http://www.ssmstoolspack.com/A great toolspack from a member of this forum (spirit).It is free and it is great.And it is the solution to your question.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-24 : 02:26:13
|
| http://vyaskn.tripod.com/search_all_columns_in_all_tables.htmMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Finding a record in database