SQL Query Analyzer Help
Using Transact-SQL Debugger
SQL Query Analyzer comes equipped with a Transact-SQL debugger that allows you to control and monitor the execution of stored procedures. The debugger supports traditional functionality such as setting breakpoints, defining watch expressions, and single stepping through procedures.
The Transact-SQL debugger in SQL Query Analyzer supports debugging against Microsoft® SQL Server™ 2000, SQL Server version 7.0, and SQL Server version 6.5 Service Pack 2.
Note It is not advisable to use the Transact-SQL debugger on a production server. While in step execution mode, the debugger can lock certain system resources that are needed by other processes.