Using the Transact-SQL Debugger

The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functions by observing their run-time behavior. You can start the debugger when you are using the Database Engine Query Editor window. By using the Transact-SQL debugger, you can do the following:

  • Step through the Transact-SQL statements in the editor line by line, or set breakpoints to stop at specific lines.

  • Step into or over Transact-SQL stored procedures, functions, or triggers that are run by the code in the editor window.

  • Watch the values that are assigned to variables, and observe system objects such as the call stack and threads.

Transact-SQL Debugger Fundamentals

Describes the functionality and the user-interface of the Transact-SQL debugger in Management Studio.

Configuring the Transact-SQL Debugger

Describes how to configure the Transact-SQL debugger for remote debugging.

Running the Transact-SQL Debugger

Describes how to start, stop, and control the operation of the Transact-SQL debugger.

Stepping Through Transact-SQL Code

Describes how to use the Transact-SQL debugger to step through code.

Viewing Transact-SQL Debugger Information

Describes how to use the debugger to view Transact-SQL data, such as parameters and variables, and system information.