When using SQL Profiler, I would like to be able to view the value of the parameter passed into a stored procedure.
For example,
Delcare @MyValue Int
SET @MyValue = 10
Exec spShowValue @MyValue
In SQL Profiler, how can I see the value of @MyValue.
Thanks.
Steve