HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlCritical

How to add the Debug button to SSMS v18?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thessmsdebugv18buttonhowadd

Problem

The Debug button is present on this version of SSMS:

But it is not present on version 18, preview 4:

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?

Solution

Debugger is deprecated in SSMS18 as @LowlyDBA said in his answer.

For 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 window

Context

StackExchange Database Administrators Q#221349, answer score: 74

Revisions (0)

No revisions yet.