How can I see SQL Server queries coming from my program?

Question

I have this C # web application, which is heavily dependent on two DLL files that I cannot see or edit. The rest of the application is visible and editable.

The application throws SQL exceptions, and I would like to see requests sent from the DLL. Is there any way to do this?

Answer 1

You can use SQL Profiler to view the queries that come to your database.

Answer 2

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

Answer 3

, , - SP_WHO2 'active' DBCC INPUTBUFFER (SPID) [sys.dm_exec_requests].

The above SQL Profiler method is preferred.