>How do you debug a stored procedure which is called from .NET method? That is, I would like to see the variables passed and some other values.
>
>TIA
You can run a profiler to get the exact call of this SP. Then you should be able to debug it from SSMS using that call.
Also, are you able to debug from VS directly?
If it's not broken, fix it until it is.
My Blog