Debugging SQL in SSMS v18.0+

Question

I've just installed SSMS v18.6 and surprisingly I noticed that there's no debug menu anymore! I'm very dependent on debugging my SQL scripts like stored procs. Can anyone explain how I can achieve this? Any help would be much appreciated.

From [dba.stackexchange.com](https://dba.stackexchange.com/questions/221349/how-to-add-the-debug-button-to-ssms-v18) : It's been removed. You'll have to use SSDT instead. It simply wasn't used by developers. In 20+ years of building data warehouse and reporting databases I've never used the debugger. If I had to use such complex logic, a proper programming language would be far better. If I really had to use complex logic I could use SQLCLR but I haven't used that either. — Panagiotis Kanavos, Oct 12 '20 at 06:24
From the linked answers, and the comments in [Brent Ozar's article about SSMS 18](https://www.brentozar.com/archive/2019/04/if-you-work-with-sql-server-youre-really-lucky/) you'll see that very few people actually used the debugger. SQL is about querying, not long procedures, and the debugger can't help with that at all. SSMS 18 removed diagrams too, but brought them back after the outcry. With the debugger, there weren't enough complains to bring it back — Panagiotis Kanavos, Oct 12 '20 at 06:27
Does this answer your question? [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

Roozbeh Y Shad · Accepted Answer · 2020-10-12T07:58:59.023

9

Debugging capabilities are no longer available in SSMS v18.0 onwards. I guess it's not been in high demand and also because of the overload it has imposed on the software. If you still need to debug your SQL scripts you can do it by using Visual Studio. There is a good video at How to debug SQL code showing you how to achieve your goal.

edited Oct 12 '20 at 07:58

answered Oct 12 '20 at 07:49

Roozbeh Y Shad

106
2

3

I don't know anyone who thinks VS debugger is better than the SSMS debugger. Imo the decision shows MS was completely out of touch with real users. – Shiv Nov 21 '22 at 05:54

score 5 · Answer 2 · edited Jul 26 '22 at 09:01

You can debug the SQL Server stored procedure and scripts with Visual Studio.NET,

Open the Visual Studio.NET and click the continue without code (link)
Connect to SQLServer in Visual Studio.NET. Menu Tools->SQL Server->New Query
Enter Sql Server Connection Data
In script note write your script or Invoke the Stored procedure or User define function
F9 or double click left of code line for out the break point
In menu SQL-> Execute with debugger
with F11 trace line By line
Complete

Debugging SQL in SSMS v18.0+

2 Answers2