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 > Set Start Parameters

Set Start Parameters

The first time you attempt to run the debug script, you are automatically prompted to set start parameters to use as an entry point, as well as providing values for all the required parameters. After initially setting these parameters, you can modify the parameters by manually setting them.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To manually set debugger start parameters

  1. Click  on the Debug toolbar.

  2. Select a procedure, function, or trigger from the list of available objects to display their parameters.

  3. Review the following for additional information:

    Value

    Enter a value for the parameter.

    Tip: Press CTRL+DELETE to set a null value.

    Collect debug trace

    Select this checkbox to generate a trace on a piece of code executed through the debugger, which can later be replayed to investigate what actually happened during the execution. See Collect and Replay Debug Traces for more information.

    The debug trace collects the following:

    • Local variables and arguments. Global variables are not collected by default, but you can enable it in the options page. 
    • Step information and callstacks.
    • Scripts of all involved code. This means that when you replay a trace, you see the script in as it looked when the trace was created regardless of whether the object has been changed in the database.
    • Script results by default. You can disable this in the options page.

    The debug trace does not collect the following:

    • Any messages.
    • The final return value from a function.

    Notes:

    • This flag is cleared after every execution
    • You can configure debug trace options in Tools | Options | Debugger | General.

  4. Repeat steps 2 and 3 for each object you want to set parameters for in the script.

 

Related Topics

About Debugging SQL