Debugging Stored Procedures with Query Analyzer


One of the great new tools available with SQL Server 2000 is the SQL Debugger built into Query Analyzer. You invoke the SQL Debugger by right-clicking on a stored procedure in the Object Browser and choosing the Debug option (see Figure 28.7).

Figure 28.7. Invoking the SQL Debugger in Query Analyzer.

graphics/28fig07.jpg

If the stored procedure has input parameters, you will be prompted to enter values or provide a null value for the parameter (see Figure 28.8).

Figure 28.8. Providing input parameter values to the SQL Debugger in Query Analyzer.

graphics/28fig08.jpg

The SQL debugger is similar to the debuggers that Microsoft provides with its other programming languages, such as Visual Basic or Visual C++ (see Figure 28.9).

Figure 28.9. The SQL Debugger interface.

graphics/28fig09.jpg

The SQL Debugger has all the features you would expect to find in a debugger:

  • Ability to set and clear break points

  • Ability to step over/into next statement

  • Ability to run to end or next breakpoint

  • Ability to view contents of local and global variables

  • Ability to display messages/results generated within stored procedure

For a more detailed discussion on using the SQL Debugger, see Chapter 6.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net