Avatar of Sam T
Sam T
 asked on

Break point in Microsoft Sql Server Management Studio 2018

Is there anyway I can put breakpoint in my scripts (T-Sql /Stored proc) in Microsoft Sql Server Management Studio 2018? With the older version before 2018 it was pretty easy to set breakpoint in the script and debug? Please let me know how one could set break point in Sql server management studio 2018?
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
Arana (G.P.)

8/22/2022 - Mon
Arana (G.P.)

debugger has been removed from SSMS 2018
you have to use something like SQL Server Data Tools (SSDT)/Visual Studio to debug a query.

open/create your query and then under the SQL Menu -> Execute with Debugger.

Or use something else, like TOAD for SQLSERVER (My personal favorite)
Sam T

ASKER
Why Microsoft has to remove this debugging tools from SSMS 2018? It would be good to have that feature on the SSMS. That is crazy!!
Anyways, this SSDT tool needs to be installed on visual studio right? Is TOAD free ?
Thanks for your help, Arana!
ASKER CERTIFIED SOLUTION
Arana (G.P.)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck