Debugging Stored Procedures Using SQL Server Management Studio

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:

Image Step through the Transact-SQL statements in the Query Editor line by line or set breakpoints to stop at specific lines.

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

Watch the values assigned ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.