How can we help you today? How can we help you today?

How do I debug TSql with breakpoints.

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.
Clint
0

Comments

1 comment

Sort by
  • Jon_Kirkwood

    Hi @...


    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


    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.