Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Debug SQL > About Debugging SQL

About Debugging SQL

Use the Debugger to debug any script that contains a procedure, or function, regardless of the SQL included in the script (i.e., SELECT statements).

Note: You cannot debug CLR stored procedures.

To debug SQL

  1. See Set Up Debugging for more information..
  2. Right-click a procedure in the Object Explorer and select Debug.
  3. Set start parameters.

    Tip: You can manually set start parameters at anytime by clicking in the Debug toolbar.

Configure Debugger Options

To...

Use this Option Page...

Set an option so function calls are not evaluated when hovering the cursor over watches

Debugger | General

Select a default desktop configuration that displays when starting or ending a debugging session

Tips:

  

Related Topics

Troubleshoot SQL Server Debugging

Set Breakpoints

Navigate Call Stacks 

Add Watches 

View Local Watches

View Global Watches