sql stored procedure

[toryee]

Hi,
I’d like to debug a stored procedure that is on the sql server but is executed from Access. The stored procedure also uses the parameters passed in from Access. How do I step it at run time? What’s the best way to do so?
Thanks.

 

[pharcyder]

simply - you can't.

It's a stored procedure and thus executed as a whole.

Perhaps you should try to change the sp to give back the values it's using and processing so you can see if they're ok.
Use the Query Analyzer for executing and give the params to the sp by hand, the messages from QA are often better than the pop-up errors from Access..

Greetings,
Jens