Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sateesh2005@gmail.com
Starting Member
3 Posts |
 Posted - 2008-03-11 : 14:10:06
|
| One of my stored procedure is having dyanamic queries. I want to do analysis on what kind of search people are currently doing and what is the output's they are getting form the application to do this, I need to trace the query’s created by this procedure. Could you please suggest how to acomplish this task? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-11 : 14:31:39
|
| SQl profiler or Setting traces. |
 |
|
|
sateesh2005@gmail.com
Starting Member
3 Posts |
Posted - 2008-03-11 : 15:27:20
|
| Is it possible to capture the result of the dynamic queries executed with in this procedure using SQP Profiler.... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-11 : 23:20:44
|
| Profiler will not give you query result. |
|
|
|
|
|
|
Monitoring Dynamic Queries performance