Click here to Skip to main content
15,669,526 members
Please Sign up or sign in to vote.
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
Updated 9-Jan-23 16:04pm

1 solution

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.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900