Debugging the Stored Procedures That You Build
It is not always easy to determine what is wrong with a stored procedure. Fortunately, SQL Server 2000 includes a very good debugger that allows you to easily step through the stored procedures that you build. To debug a stored procedure:
1. | Launch Query Analyzer. |
2. | Open the Object Browser. |
3. | Locate the stored procedure that you want to debug. |
4. | Right-click and select Debug. The Debug Procedure dialog box appears (see Figure 8.28).
Figure 8.28. The Debug Procedure dialog box allows you to set the values of the parameters in your stored procedure.
|
5. | Click each parameter and type the appropriate value ... |
Get Alison Balter's Mastering Access 2002 Enterprise Development 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.
