trackvalue of variable in profiler

• Geetha-245549

  SSC Rookie

  Points: 41

  More actions

  November 16, 2005 at 5:57 am

  #111334

  HI,

  can anybody tell me how to get a value of variable that is passed

  through a procedure like exec proc(@a,@b).

  want to know the value of a and b while running the procedure

  through the profiler

  thanks

   

   

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  November 17, 2005 at 9:51 am

  #604470

  Run your profiler and chooose text data for the data column.  It will output the procedure as well as the params passed.