Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tomjacob
Starting Member
8 Posts |
 Posted - 2002-03-04 : 14:22:06
|
| Hi Folks, I have a stored procedure, sp_fetch_new, which accepts a parameter (datetime). sp_fetch_new '12/12/2001'This parameter is dynamic and will change accordingly.How can i know what paramater it has taken when it ran. I looked in profiler (trace) but it is not giving the paramater value . Just the sp's name.I would like to know, in sQL 7.0, how can i see the parameter a sp has taken when it executed.Please help. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 15:17:15
|
| Profiler should show everything, not just the SP name.Maybe you didn't capture the right events, but i know it shows the parameters.-Chad |
 |
|
|
tomjacob
Starting Member
8 Posts |
Posted - 2002-03-04 : 15:32:21
|
Chadmat,Would ypu please tell me what is that event.Tomquote:
Profiler should show everything, not just the SP name.Maybe you didn't capture the right events, but i know it shows the parameters.-Chad
|
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 15:36:22
|
| Just tested it.The TextData of SQL:BatchCompleted shows the parameter.-Chad |
|
|
|
|
|
|
Stored Procedure Parameter !!!!!