>Thank you. I will ready and learn what the article says. But in my case I need to "debug" not from VS but running in production. This is why I thought that creating some "crumbs" files would be possible.
>
>Can't you debug the app and get the values at a specific point in time and them debug the SP by feeding those values into it?

You can use the SQL profiler to intercept the call and see exactly what's being passed to the sp call. Then you can feed those exact values to the sp and see what is going on..