Geek Answers Handbook

Ability to debug from .net code to SQL Server stored procedure code?

Is it possible to directly immerse yourself in SQL Server stored procedures from .net code? Therefore, when you debug step by step in .net, I would like to enter the called stored procedure.

I know how to debug them separately, but I would like to join these debugging sessions in order to get some time.

+4
source share
1 answer

I always found this a bit complicated, but it is possible.

First you need to enable T-SQL debugging in the IDE for the project / solution, then you need to configure the database connection as part of the project / solution.

Actually, interfering with the stored procedure seems problematic, but if you open the code of the stored procedure and explicitly set a breakpoint there, it will fall into the breakpoint.

+3
source

More articles:


All Articles