Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to debug T-SQL with SQL Server Management Studio 2017?

The latest changelog (18.0 Preview 7) of SQL Server Management Studio announced, that the T-SQL Debugger is deprecated.

What are the alternatives for the future? Can someone understand this decision? I fear that removing a fundamental development tool like this will effect many developers.

like image 490
ˈvɔlə Avatar asked Mar 28 '19 10:03

ˈvɔlə


People also ask

How do I debug SQL stored procedure in SQL server Management Studio 19?

To debugging SP, go to database->Programmability->Stored Procedures-> right click the procedure you want to debug->select Debug Procedure.

How do I start Transact-SQL debugger?

You can start the Transact-SQL debugger after you open a Database Engine Query Editor window. Then, you can run your Transact-SQL code in debug mode until you stop the debugger. You can set options to customize how the debugger runs. This feature works with SSMS version 17.9.

How debug SQL procedure in SQL Server?

Click the left window margin to add a breakpoint to the EXEC statement. Press the drop-down arrow on the green arrow button in the Transact-SQL editor toolbar and select Execute with Debugger to execute the query with debugging on. Alternately, you can start debugging from SQL Server Object Explorer.


1 Answers

  • It seems that Microsoft may have temporarily moved the branch of debugging from SSMS18 to SQLServer Data Tools (SSDT).
  • According to developers of DBA Stackexchange community, there is another alternative way to debugging, since Debugger is deprecated in SSMS18.
  • Here is the link that shows how to achieve debugging : How to add the Debug button to SSMS v18?

ALTERNATIVE: ??

  • Just when I thought there would be no solution to this coming out any time soon, to my surprise there might be one.
  • There is a tool that I've come across lately while dabbling into this debugger thing in SSMS18 out of curiosity, which goes by the name SQL Complete.
  • The company Devart apparently specializes in Database products and provides toolsplug-ins for various major databases.
  • Here is a small video of them briefing about the debugging feature in their tool SQL Debugger in the new version of dbForge SQL Complete
  • It's available on Visual Studio Marketplace.
like image 85
Tahir77667 Avatar answered Oct 10 '22 22:10

Tahir77667