SQL Server debug Stored Procedure from .NET code

Question

I'm wondering if there's a way to debug a stored procedure at the time it's called from .NET code? What are my possibilities?

I'm using Visual Studio 2013 Community Edition and SQL Server 2014

You can use a sql profiler to see the complete stored procedure call and then call directly in sql management studio to debug it. — CrApHeR
– CrApHeR, Commented Jul 7, 2015 at 11:58

pzaj · Accepted Answer · 2015-07-07 12:29:59Z

1

I have managed to figure it out myself.

It's quite similar to what you can find in VS 2010.

I had to import database as a project to my solution.
Turn on SQL Debugging in my application project properties.
Re-open my project.
Connect to my SQL Database through SQL Server Object Explorer.
Right click on my SQL Server I connected to earlier and check "application debugging".
Find SP I wanted to debug, double click on it, set my breakpoint (it says it will not be hit, but eventually it will).
Launch my application using debugger.

Everything now works as expected, the debugger stops at my breakpoint with no problem.

answered Jul 7, 2015 at 12:29

pzaj

1,0923 gold badges17 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1