How do I debug TSql with breakpoints.

Clint_H

I've been using Sql Prompt for a while and I'm not sure where to ask this question, but is there a way with this or another product to set breakpoints and step through SQL code?

I've seen a ton of articles on how to "sort of" do this, but nothing definitive.

Jon_Kirkwood

Hi @Clint_H

Thank you for reaching out on the Redgate Forums.

Unfortunately, there isn't much currently available within the Redgate tools to meet your request for breakpoint/line debugging.

We have our SQL Test product which is geared towards unit testing in SMSS. This tool is a GUI for the open source tSQLt framework. It may be worth looking into this as a possible solution.

I had a scan of our Uservoice page, where users can request features & functionality to be implemented into Redgate products, and did come across a request to implement a debugger into SQL Prompt.

https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/44205594-debugger-for-sql-code

Voting for items in Uservoice helps our development team prioritise requested features so I would recommend voting if this is of interest to you.

Other than that, we would recommend debugging to be conducted directly through SMSS or Visual Studio

Microsoft have a document published on their T-SQL debugger which may be of use.

https://docs.microsoft.com/en-us/sql/ssms/scripting/transact-sql-debugger?view=sql-server-ver15