I added the add-in VB T-SQL Debugger from Add-In Manager. I am using VB6. When I start T-SQL Debugger, I get a window saying Visual Basic Batch T-SQL Debugger where I set the DSN and select my stored proc on the second tab. When I click on Execute, it starts the Automation Manager and takes me to my stored proc. Howver, when I do Debug and then F8, I get the message:
The following SQL Sever error occurred: 37000: Cursor is not open
When I click on OK, I get the following message:
The query could not be debugged due to a problem coordinating events with the sever. Check the server and client log to find the exact cause, fix the problem and try again.
Would appreciate an answer from anyone.