I installed SSMS 19 Preview 4 and it doesn't have a Debug Menu or Debugging option. I also learnt that SSMS V17 was the last version with that capability. Then I decided to try Azure Data Studio, but still not able to see debug option. Can someone direct me how I can debug an SP using Azure Data Studio IDE?
This feature is not available. There are other ways to do, but they aren't very user friendly.
Developers are used to their tools having built-in ways to show what line of code is running now, output the current content of variables, echo back progress messages, etc. For a while, SQL Server Management Studio also had a debugger, but it was taken out of SSMS v18 and newer versions. Even when it was around, though, I wasn’t a big fan: SQL Server would literally stop processing while it stepped through your query. This was disastrous if your query was holding out locks that stopped other peoples’ queries from moving forward – and you just know people were using it in production.
- Option 1: Use PRINT statements.
- Option 2: Use RAISERROR
- Option 3: Use Table Variables.
However in all cases you have to edit your code.
I suggest you to download SSMS 17.9.1 since this version has a debug option right next to the run button. You can donwload it from the link bellow.