Debugging TSQL in SSMS

Question

What techniques can I use to debug TSQL code now the debugger in SSMS 18 has been deprecated/removed?

Yes, looks the Debug has been deprecated!!! – Tony Dong Feb 19 '20 at 23:35 — Tony Dong, Feb 19 '20 at 23:35

score 2 · Answer 1 · answered May 01 '19 at 09:27

2

The way I am using might not the best, however, just to reassure you that this is possible and it has been working fine for me:

if you really like the debug least for now I am using both versions of ssms, the 17.9 and the 18 side by side as you can see on the picture below:

I use sql server from 2008 r2 up to sql server 2017.

answered May 01 '19 at 09:27

Marcello Miorelli

16,170
52
163
300

Curious why use v18 at all? Without debugging I really have no use for it personally. – Shiv Jul 08 '20 at 02:57
1

Anyone who thinks deprecation of debug was a bad idea please vote for it to be restored https://feedback.azure.com/forums/908035-sql-server/suggestions/35881492-put-debugger-back-into-ssms-18 – Shiv Jul 08 '20 at 02:59

Debugging TSQL in SSMS

1 Answers1