Saturday, May 31, 2014

How to get the Parameters of a Parameterized Query from dm_exec_sql_text

Hi,


How can I get The values for each subsequent query that uses the cached plan can be gleaned from a SQL Trace or Extended Events trace of the individual BatchCompleted and RpcBatchCompleted events.


Can you please provide me a sample Query?


Thanks,


Rajib


No comments:

Post a Comment