Debug is not visible in sql management studio

  • pols

    SSC Eights!

    Points: 861

    Hi,

    we have installed sql server 2016 standard edition.

    developers want to debug the stored procedure. In the management studio we didn't see 'Debug' option at all. I tried add remove button but nothing working. Please help me to add the debug option in sql server 2016 management studio.

    Thanks,

    Jo

  • Alejandro Santana

    SSCommitted

    Points: 1777

    They have removed the debugger in the latest version of SQL Server Management Studio 18+, download earlier versions for the SSMS with debugger.

    🙁

    Greetings,

  • BrownCoat42

    SSC Enthusiast

    Points: 117

    I'd switch to SQL server data tools

  • Jeff Moden

    SSC Guru

    Points: 995976

    Alejandro Santana wrote:

    They have removed the debugger in the latest version of SQL Server Management Studio 18+, download earlier versions for the SSMS with debugger. 🙁 Greetings,

    I wish MS would stop making such "improvements".  They did the same thing with "Diagrams".  There was an uproar about that and, very fortunately, the supposedly brought it back.  Perhaps a similar uproar would bring back the debugger.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Sue_H

    SSC Guru

    Points: 90588

    Jeff Moden wrote:

    I wish MS would stop making such "improvements".  They did the same thing with "Diagrams".  There was an uproar about that and, very fortunately, the supposedly brought it back.  Perhaps a similar uproar would bring back the debugger.

    The "latest and greatest" is often not the greatest. I just never updated from 17.9. It's getting old to update and guess what functionality exists, is broken, doesn't work, etc. and trying to guess if an issue is the SSMS version or something else.

    Sue

  • pols

    SSC Eights!

    Points: 861

    Thank you all for ur replies . The installed version is ssms 18.1 which debug is deprecated by microsoft. Not sure y they have done. So I uninstalled the SSMS 18.1 And reinstalled the previous version 17.9 SSMS.

    The Debug option is there in ssms 17.9

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply