Did you know? SQL Server 2008 includes Transact-SQL Debugger

By on June 14th, 2008

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. 

Check out a screencast about the new T-SQL Debugger in SQL Server 2008 via MSN Video below, or if you prefer Youtube or download.

Categorized under: 2008, SQL Server, T-SQL.
Tagged with: no tags.

Leave a Response