How to debug stored procedure

Question

1.00/5 (1 vote)

See more:

I have a job interview, they failed me due to one question, they asked me if you have a stored procedure more than 1000 lines how you debug the stored procedure, I do not have the answer, can anyone help me to give this answer,

What I have tried:

I said in SSMS there is Debug option, we can start debugging

Posted 9-Jan-23 13:11pm

khan baba20

Updated 9-Jan-23 16:04pm

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2023-01-09T16:04:00

Solution 1

There are couple of ways to debug stored procedure:
- Using SQL Management studio (SSMS)
- Using Visual Studio

Refer: Debug your stored procedure[^]

At times, I also used to use logging in SP's to assess certain things. Cannot say what your interviewer was looking for though.

Posted 9-Jan-23 16:04pm

Sandeep Mewara

How to debug stored procedure

1 solution

Solution 1

Add your solution here

Preview 0

How to debug stored procedure

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us