After right-clicking on stored procedure on Query Analyzer Object Browser, I'm able only to enter input parameters and run sp from start to end. Breakpoints don't work. No debugging in the debugger happens! Am I'm missing something?
What did you do to try to set the breakpoints?
Mine comes up at the first line of executable code and then I can use F9 to set breakpoints. But it won't set on anything but executable code. You can't set them on comments, declaration statements, or blank lines. Then F5 to run the procedure and it stops at the breakpoints.
What drives me crazy is that I can't seem to get it to let me change the code while debugging. I can change the variable values, but if I see something that I need to change I have to change it with an ALter procedure in another window and then start the debugger again for the changed procedure. This is awfuly awkward to me, I miss being able to change a line and then back up to it and start executing again like I can when I do VBA, VB or VB.NET code.
SQLSister!
I set a toggle breakpoint on, say, 3rd or 5th Select statement of the procedure, then run it, and it executes the entire procedure anyway. During the execution, Step Into-Over-Out buttons are highlighted, but after they are not. Can't do much with this tool. Any hints?
Thanks.
Andrei
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.