Yes, you can see the input parameter values.  Use RPC:Starting to get

initial values and RPC:Completed to get OUTPUT values (if you have any), if

you're using parameterized or prepared statements.  Otherwise, use

SQL:BatchStarting.





"iter" <anonymous@discussions.microsoft.com> wrote in message

news:341EE581-8CF3-42CE-8565-DF159E7BD95A@microsoft.com...

> can I use sql profiler to debug stored procedure, for example, when

application runing, can I get infomation in profiler, such as  value of

variable in stored procedure, especially input parameter. Because I need to

know what is value of input parameter I get from client side. Thanks

>

>