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 |
|
bfullen
Starting Member
1 Post |
 Posted - 2011-01-13 : 10:11:28
|
| I am trying to re-engineer an application which has a SQL 2005 back end in order to create a report. The data in the application is on multiple screens and the user needs to jump around to gather all the information on a daily basis. I need to create a report the user can run in order to get all the required info. My issue is, ai do not know which tables or columns the particular data is in. I am currently going table by table, but there are over 100 tables in the DB. is there some script I could run where I provide the field data from the application and have the script loop through every table and column and return a result with every table and column the string exists in?Thank you.Bill Fullen |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-01-13 : 10:14:00
|
| You can run SQL profiler to see what statement(s) are run when you populate the screen. This would be the best place to start. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-13 : 10:14:32
|
You could run a profiler trace to find what tables the application is reading from. Rick is faster than I am  |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-01-13 : 10:19:37
|
That makes a change.. You beat me on 1 though..  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
What table is my data in