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

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 开发者_Go百科server-side tracing but my app talks to at least five different servers, so that's pretty hard to do effectively.

Any recommendations?

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.