Fail to debug a SQL procedure in Visual Studio 2022

Question

I try to debug a procedure in my VS2022, but, it's not works when I set to debug mode.

Answer 1

Hi,

it seems that this is an issue in non-english versions of VS 2022. The workaround for the german version was to install the english language package and use it:

https://developercommunity.visualstudio.com/t/SQL-debugger-cant-step-into-VS2022-17/10243578

I don't have any clue why Microsoft does not fix this.

Answer 2

Hi @Maciel, Juliano Ribeiro de Souza,

Could you click the play button after a sentence?

Also, I recommend you to read this document:

https://learn.microsoft.com/en-us/visualstudio/debugger/error-unable-to-access-the-sql-server-debugging-interface?view=vs-2022

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

Try to execute in debug mode.

Answer 4

Hi @Maciel, Juliano Ribeiro de Souza,

Have you tried rebuilding your project or restarting Visual Studio? I had the same problem before, and it was finally solved by restarting Visual Studio.

By the way, you need to make sure that your SSDT is installed and Enabled.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

Answer 5

I have the same problem, The step into doesn't work, Simply the execution go to the end of procedure.