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?
SQL Server – How to Add Debug Button to SSMS v18
sql serverssms
Related Solutions
In 2005 at least, hit F5 to re-run your query. SSMS will determine it is no longer connected and then prompt you to reconnect. If I recall correctly, 2005 will put you back into the same database while 2008 puts you into your default catalog. A second execution of F5 will actually run the command. I've never had a semaphore timeout but it works for other disconnect scenarios.
The option is still there (although this is from SQL Server 2014):
You don't normally have to restart SSMS, just open a new query window.
Best Answer
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.
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