Query text - Procedure parameter values

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  October 21, 2013 at 4:07 am

  #278990

  Hi all

  I've got a pretty standard report that uses dm_exec_query_stats to dig out various bits and pieces of info regarding processes that belong to a 3rd party app. I use a cross apply to dm_exec_sql_text to get the SQL however I have noticed that parameter values don't show up in the results, I do get the declaration just nothing else really!

  Is there another view that I can use along with the above, or separate even, where I can find these values?

  Many thanks

  D

  'Only he who wanders finds new paths'

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  October 21, 2013 at 4:46 am

  #1660078

  Actually, thinking I can get those from exec_query_plan perhaps?

  'Only he who wanders finds new paths'