How to add the Debug button to SSMS v18?

290 Asked by ChristopherPaterson in Salesforce , Asked on Apr 23, 2021

The Debug button is present on this version of SSMS: enter image description here

But it is not present on version 18, preview 4: enter image description here

I have tried in several ways to add the Debug button to my SSMS but not successful.Is there a way to add the Debug button to SSMS v18?

Answered by Daniel BAKER

Debugger is deprecated in SSMS18 in sql server debug stored procedureFor those who look for an alternative, you can use SQL Server Data Tools (SSDT)/Visual Studio to debug a query.

Connect to a SQL server (in Tools menu)
Open a new query (Server explorer, right click, new query)
Type in your query
Execute with Debugger

From the SQL menu

From the Drop down list next to the execute icon in the query window
From the context menu in the query wondow
Hope this helps you understand sql server debug stored procedure.

How to add the Debug button to SSMS v18?

Your Answer