DEBUG SQL SERVER STORED PROCEDURE FROM .NET MANAGED CODE 

Debugging stored procedure from .net [C#/VB.Net] code.
support.micros...
Limitations of stored procedure debugging
1) The following is a list of limitations that you
may encounter when you debug stored procedures and that you do not encounter when you debug Visual Studio code:
2) You cannot "break" execution.
3) You cannot "edit and continue."
4) You cannot change the order of statement execution.
5) Although you can change the value of variables,
your changes may not take effect because the variable values are cached.
6) Output from the SQL PRINT statement is not displayed.