see parameter values in profiler

• krypto69

  SSChampion

  Points: 13604

  More actions

  May 20, 2010 at 8:29 am

  #221275

  I had a dev ask me why he can't see some of the parameter values in profiler for example:

  If @nTranLimit < @pnAmt

  He wants to know the value of both parameters..

  How can I show him that?

• ashish 10950

  SSC-Addicted

  Points: 422

  More actions

  May 26, 2010 at 6:46 am

  #1172661

  Hi , Just select in profiler->event Selection -> TSQL

  SQL:STMTStarting , and STMTCompleted.

  Regards

  Ashish Gupta