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 |
|
cijuvarghese
Starting Member
12 Posts |
 Posted - 2006-11-16 : 03:16:57
|
| Hi,Is it possible to find the Table name using any of the data it contains? I meant from any systables, will we able to relate?Ciju |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-16 : 03:26:48
|
| Using data it is not possible. Using column name it is possibleWhy do you need this?Give us more detailsMadhivananFailing to plan is Planning to fail |
 |
|
|
cijuvarghese
Starting Member
12 Posts |
Posted - 2006-11-16 : 03:32:20
|
| OK. wat i meant is, we got a report generated from the database and we are not aware of the query using which it has been generated. In this case, we need to search all the tables in the database to find the correct table, the data belongs. if the db is big enough??? |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-16 : 04:11:44
|
| why dont you on a profiler? and then review the trace file you will automatically came to know, about every query passed to your database.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
cijuvarghese
Starting Member
12 Posts |
Posted - 2006-11-16 : 04:39:56
|
| I am sorry.. we are not generating the report. we are jst getting a text file which is having the data. Also we do not know when this will be generating(for analyzing on profiler) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
cijuvarghese
Starting Member
12 Posts |
Posted - 2006-11-16 : 05:47:43
|
| Hey this is really good.. thanks!!! |
|
|
|
|
|
|
Table name from value