| Author |
Locating recently edited tables
|
|
| Ib Schrader 2006-12-13, 7:12 pm |
| Hi
Pop quiz: Let's say a user types in "Pennsylvania Av." in his customer
application. This application keeps its data in a SQL 2000 database.
What would be the easiest way for me to figure out which table got updated
with the "Pennsylvania Av." string?`
I don't care whether the solution is to change some view settings in my SQL
GUI or if I can write some t-sql code and output the solution for me, I just
need to figure out where the application stores the darn addresses.
Thanks in advance for any input
Ib
| |
| Tibor Karaszi 2006-12-13, 7:12 pm |
| Use Profiler. You can catch the SQL statements submitted by the app. You can even catch the
execution plan and from that determine what tables were hit (if that approach is better than working
with the SQL submitted).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Ib Schrader" <ibschrader@gmail.com> wrote in message news:ez2gcoqHHHA.1248@TK2MSFTNGP02.phx.gbl...
> Hi
>
> Pop quiz: Let's say a user types in "Pennsylvania Av." in his customer application. This
> application keeps its data in a SQL 2000 database.
>
> What would be the easiest way for me to figure out which table got updated with the "Pennsylvania
> Av." string?`
>
> I don't care whether the solution is to change some view settings in my SQL GUI or if I can write
> some t-sql code and output the solution for me, I just need to figure out where the application
> stores the darn addresses.
>
> Thanks in advance for any input
> Ib
>
| |
| Uri Dimant 2006-12-13, 7:12 pm |
| Ib
Do you store "Pennsylvania Av." value in many tables?
"Ib Schrader" <ibschrader@gmail.com> wrote in message
news:ez2gcoqHHHA.1248@TK2MSFTNGP02.phx.gbl...
> Hi
>
> Pop quiz: Let's say a user types in "Pennsylvania Av." in his customer
> application. This application keeps its data in a SQL 2000 database.
>
> What would be the easiest way for me to figure out which table got updated
> with the "Pennsylvania Av." string?`
>
> I don't care whether the solution is to change some view settings in my
> SQL GUI or if I can write some t-sql code and output the solution for me,
> I just need to figure out where the application stores the darn addresses.
>
> Thanks in advance for any input
> Ib
>
| |
| Ib Schrader 2006-12-13, 7:12 pm |
|
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:uVUvutqHHHA.3676@TK2MSFTNGP03.phx.gbl...
> Ib
>
> Do you store "Pennsylvania Av." value in many tables?
I don't know that. The exercise is to locate which tables got updated by the
application. I don't know how many that is, but I suspect it's just one
table that stores the data.
Thanks for the profiler idea..I'll look into that.
Ib
| |
| Ib Schrader 2006-12-13, 7:12 pm |
| The profiler helped me catch which table got updated.
Thank you very much.
Ib
|
|
|
|