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 |
|
yalgaar
Starting Member
43 Posts |
 Posted - 2006-02-24 : 11:59:26
|
| Sorry to repost this again since I did not get any replies on my previous post.I would like to know if there is any way to find out if a string "ABCD" exist in any rows, any tables, any database?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-24 : 12:18:08
|
| You did get a reply..http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62260 |
 |
|
|
yalgaar
Starting Member
43 Posts |
Posted - 2006-02-24 : 19:22:52
|
| Thanks. This link really helped me out. But this will only find it in all tables in a specific database.I still need it to find it in all tables of ALL database.Is there some way except manually doing it on each database?Thanks |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-24 : 23:20:18
|
| U can extend that answer along with the stored procedure : sp_databaseswhich gives u all the database namesU may have to have an outer loop to loop thru all DBsI guess the process would take quite a long time |
|
|
|
yalgaar
Starting Member
43 Posts |
Posted - 2006-02-26 : 10:23:52
|
| I am really not a programmer, so I would greatly appreciate if somebody could modify the original script while adding more functionality on it that would scan all databases. |
|
|
|
yalgaar
Starting Member
43 Posts |
Posted - 2006-02-26 : 10:24:03
|
| I am really not a programmer, so I would greatly appreciate if somebody could modify the original script while adding more functionality on it that would scan all databases. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-27 : 00:46:15
|
| One simple method is to create that stored procedure in all databases and run them. After getting desired results drop that spMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Finding Data in SQL Database