How to Debug a Stored Procedure
Several different methods can be used to debug a stored procedure. The following is a listing of popular debugging methods:
Transact-SQL Debugger
Transact-SQL Debug Statements
Other Debugging Tools
TIP
SQL Server finally has an integrated stored procedure debugger! Starting with SQL Server 2000, the stored procedure debugger is part of the Query Analyzer. Previous versions required the use of Visual Studio or other non-SQL Server products to debug a stored procedure.
Transact-SQL Debugger
The following are the steps to use the Transact-SQL Debugger:
CAUTION
It is not recommended that you use the Transact-SQL Debugger on a production server. When using the Step Execution mode feature, the debugger can produce extensive ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
