September 2010
Intermediate to advanced
1704 pages
111h 8m
English
One of the great tools available in the SQL Server 2000 Query Analyzer, the built-in SQL Debugger, was left out of SQL Server Management Studio (SSMS) in SQL Server 2005. Fortunately, SQL Server 2008 brings the T-SQL debugger back to SSMS.
The Transact-SQL debugger in SQL Server Management Studio enables you to step through Transact-SQL scripts, stored procedures, triggers, and functions as they are running. The Transact-SQL debugger allows you to do the following:
• Step through the Transact-SQL statements in the Query Editor line by line or set breakpoints to stop at specific lines.
• Step into or over Transact-SQL stored procedures, functions, or triggers run by the code in the ...