Introduction
Debugging is a necessary process in almost any new software development process.
We write complex business logic in store procedure and many companies using store procedure extensively. One of my ERP project have stored procedure which has more then 50 thousand lines and it was very difficult for me to debug them. I had struggled with really challenging bugs in my SQL store procedures. I had been spending many days and sometime weeks just to figure out the exact error for my store procedures.
I am sharing my experience so that you can gain from knowledge and improve your debugging skill for SQL store procedure.
Reader is assumed to have basic knowledge of Visual Studio and SQL store procedures.
