How to trace the sql queries that my windows app generates?

Question

I want to do sql client-side tracing to see the scope of databases and queries that my local Windows application is generating.

Everyone on the Web talks about server-side tracing but my app talks to at least five different servers, so that's pretty hard to do effectively.

Any recommendations?

Answer 1

If you have a Data access layer, or a limited # of functions that actually execute the sql, you could build in a logging mechanism that you could enable/disable for debugging purposes. Sorry if that's a generic answer.