>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?