<div>
debugger has been removed from SSMS 2018<br />
you have to use something like SQL Server Data Tools (SSDT)/Visual Studio to debug a query.<br />
<br />
open/create your query and then under the SQL Menu -&gt; Execute with Debugger.<br />
<br />
Or use something else, like TOAD for SQLSERVER (My personal favorite)
</div>


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)

<div>
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!! <br>Anyways, this SSDT tool needs to be installed on visual studio right? Is TOAD free ? <br>Thanks for your help, Arana!
</div>


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!

software & controls

Sam T

<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Break point in Microsoft Sql Server Management Studio 2018

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.