2

New bie here for sql server. In latest SSMS 18.2 I don't see debugger, and I don't have a link to old SSMS 16. If I were to use latest SSMS 18.2 how do I debug stored procedures for sql server 2016? whats the alternative?

user8371676
  • 55
  • 1
  • 5
  • Duplicate of [How do you debug or step through the code in SQL Server Management Studio 18?](https://stackoverflow.com/questions/56565764/how-do-you-debug-or-step-through-the-code-in-sql-server-management-studio-18) – TylerH Oct 01 '21 at 14:13

1 Answers1

7

There is a Debugger in the menus up to V17:

enter image description here

Unfortunately, Microsoft removed the Debugger in V18 and expect you to use Visual Studio to debug SQL Server.

You can still download SSMS V17.9 here: https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-2017#download-ssms-1791

daShier
  • 2,056
  • 2
  • 8
  • 14
  • Thank you for taking time to respond, can you have two SSMS installed on one windows machine ? – user8371676 Aug 01 '19 at 15:52
  • 1
    Yes, I have both V17 and V18 installed on the same machine. However, don't discount the idea of using Visual Studio. The SQL editing window is much nicer than in SSMS. – daShier Aug 01 '19 at 16:31
  • BTW: @user8371676, the best thank you is to check off that this answer solved your question. Thanks. – daShier Aug 01 '19 at 18:58