Debug T-SQL database objects

Last modified: May 28, 2025

This section provides guidance on using the built-in debugger to analyze and troubleshoot T-SQL code. It covers configuring the debugger, stepping through stored procedures, functions, triggers, and SQL scripts, as well as managing execution flow and breakpoints. Shortcut keys and execution controls are also included to help streamline the debugging process and improve code reliability.

In this section

Configure the Debugger

Debugger overview

Debug a stored procedure

Debug a stored function

Debug a trigger

Debug a SQL script

Execution control

Work with breakpoints

Debugger shortcut keys