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
Last Comment
Arana (G.P.)
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!
Anyways, this SSDT tool needs to be installed on visual studio right? Is TOAD free ?
Thanks for your help, Arana!
ASKER CERTIFIED SOLUTION
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.
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)