A question on how to get bind variables actual values

• ranmel

  Old Hand

  Points: 364

  More actions

  October 29, 2009 at 3:15 pm

  #227562

  How can I see bind variables of an SQL statement.

  For example,

  create PROCEDURE sample_sp_test

  (@param1 int,

  @param2 int)

  AS

  SELECT @param1, @param2

  GO

  EXEc sample_sp_test 1,4

  EXEc sample_sp_test 1,3

  EXEc sample_sp_test 1,5

  I want to be able to see

  instead of :

  SELECT @param1, @param2

  the actual values

  for example:

  SELECT 1,4

  I can not see it on SQL Server profiler

  Note that in this sample I used the parameters on the select section and not in the where clause

  but I believe that you understood my problem.

  Thanks in advance

  Ran

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  October 29, 2009 at 4:48 pm

  #1072895

  You won't see it in Profiler like that. You'd only see

  sp_test 1, 4

  for a stored procedure call in Profiler.

• ranmel

  Old Hand

  Points: 364

  More actions

  October 30, 2009 at 5:57 am

  #1073042

  so how can I do it ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  October 30, 2009 at 7:57 am

  #1073147

  you run profiler, and pick the Stored procedure events. I see it in

  SQL: Batchstarting

  SP:starting

  SQL:BatchCompleted.

• ranmel

  Old Hand

  Points: 364

  More actions

  November 1, 2009 at 12:55 am

  #1073560

  this is not solving my problem because there are scenarios that I can not see the parameters ,

  I am searching for a general solution that I believe can not be solved using SQL profiler.

  maybe there is speciel Flag in SQL Server that save the bind variables.