How can i see the SQL Server queries coming from my program?

Question

I have this c# web app that relies heavily on two dll files that i can't see nor edit. The rest of the app is visible and editable.

The app generates SQL exceptions, and i would like to see the queries sent from the DLLs. Is there a way to do that?

Answer 1

You can use SQL Profiler to see the queries that goes to your database.

Answer 2

For SQL Server 2005/2008 Express you can try AnjLab's SQL Profiler.

Answer 3

Another way to see what is running is SP_WHO2 'active' combined with DBCC INPUTBUFFER(SPID) or query the [sys.dm_exec_requests].

The SQL Profiler mentioned above is the preferred method.