SQL Server 2008 T-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.


  1. thanks for the video it helped me get started. the resolution works better on full screen and if you set to 480p on the video bar of the video itself.(next to volume)

  2. Thanks for the video.
    I hope to make its resolution higher + the sound was little bit low (I felt sleepy).

    It is nice video … keep the good work up!

    Thanks again.

Leave a comment