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 |
|
smithjack04
Starting Member
2 Posts |
 Posted - 2005-12-28 : 18:54:38
|
| Hi, this is my first post on these forums, so please excuse me if this topic has already been covered.I'm currently working in a power station for student vacation work placement. I need to export data from a database that gets it's data from machinery and inputs out in the plant. The machines that provide this input put it into a database, and I need to find the relevant data to export.My problem is that, in some cases, the sample data that i'm given may be under different field names, in a completely unrelated table. I was looking for a way to search the entire database (250+ tables) for a certain string, so I can find where it is in the database, and run queries on the table it originates from. For example:My sample data shows me that I have an object with the ID Y03A3DEA_TH1. I know this ID will occur somewhere else in the database, but i'm just not sure where.If anyone knows of any way that I can search the entire database for specific data, either using tools in MS SQL 2000, or 3rd party apps, i would greatly appreciate their help.Thanks a lot,Jack Smith |
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
smithjack04
Starting Member
2 Posts |
Posted - 2005-12-28 : 19:13:29
|
| thanks :Di'll get back to you with my results! |
 |
|
|
|
|
|
|
|
Searching an entire database