Last post Jan 02, 2017 08:10 AM by Nilishere
Dec 31, 2016 03:11 PM|JAYHAWKER|LINK
When I am in debug mode in Visual studio, how do I have it stop at break points in SQL stored procedures as I am debugging? I set the break points, but it never stops. What am I doing wrong?
Jan 01, 2017 08:50 AM|Nilishere|LINK
You can set the breakpoint where you are using executenonquery() or executereader() to execute the stored procedure. But if you want to debug each line inside the stored procedure then you need to do it from sql server management studio.
Check the below links for debugging
Jan 01, 2017 02:05 PM|JAYHAWKER|LINK
Thanks for the reply. I can debug by executing the procedure, the window pops up and I put some parameter in if needed, but what I can't figure out is how to have the debugger stop in a stored procedure when being called from Visual studio when debugging
a project and calling the stored procedure. I am wanting it to stop at a break point set in SQL Management studio automatically, pop the locals window up with the parameters being fed from the web project automatically. I may have missed how to do that,
but didn't see it.
Thanks again for the response.
Jan 02, 2017 08:10 AM|Nilishere|LINK
in that case you need to connect via the "SQL Server Object Explorer" window. Once you have the connection in that window, the "Allow SQL/CLR Debugging" and "Application Debugging" setting appear on the right-click context menu of your database.This is
working for VS2013 so you have to check the same for VS2015.
Please check the below link for more reference