T-SQL Debugging Options Dialog Box

Lets you customize the T-SQL debugger.

To view this dialog, add the T-SQL Debugger to the development environment via the Add-In Manager command on the Add-Ins menu. Then, with the debugger loaded, choose T-SQL Debugging Options on the Tools menu.

Dialog Box Options

Automatically step into Stored Procedures through RDO and ADO connections

When selected, automatically steps into the stored procedure and displays the T-SQL Debugger each time you step into an RDO or ADO method that executes a stored procedure.

Once you select this option, if you step into a line of code that executes an RDO method that invokes a stored procedure, the debugger automatically starts.

Use Safe Mode (transaction rollback) for Stored Procedure calls

When selected, turns on Safe Mode, which automatically rolls back any design-time queries that you debug.

Limit SQL Output to the following number of lines per resultset

Limits the number of rows that appear in the T-SQL Debugger’s Output window when you debug design-time queries. The default is 500 lines per result set.

Login Timeout value for retrieving stored procedure text

Sets the login timeout value that the debugger uses to connect to the database to get the internal SQL State. The default is 10000.