Reputation: 1323
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?
Upvotes: 3
Views: 803
Reputation: 6958
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.
Upvotes: 1
Reputation: 48108
You can use SQL Profiler to see the queries that goes to your database.
Upvotes: 13