TRANSACT SQL DEBUGGER V2K
SQL Server 2000 has quite a bit of new and improved functionality over 
the previous versions. And although there was some debugging 
functionality in past versions, it was sometimes cumbersome to 
configure. The new isqlw.exe, or Query Analyzer tool, allows you to 
debug a stored procedure, trigger, or user-defined function with 
considerable ease.

This tip is based on a Windows 2000 Professional/SQL Server 2000 
platform. You can debug against SQL Server versions 2000, 7.0, and 6.5 
Service Pack 2.

1. SQL Server should be set up to run as a service under a valid domain 
account.
2. Open the isqlw.exe, or Query Analyzer tool, and login.
3. Go to Tools | Object Browser | Show/Hide or press [F8] to display 
the object browser window.
4. Browse to a database, choose Stored Procedure, and select a stored 
procedure that you would like to debug or step through.
5. Right-click the procedure and select Debug.

A debug window will display and enable you to supply parameters (if 
required) for execution. When you click the Execute button, the window 
will change and let you step through the Transact SQL code, set 
breakpoints, and step in/out of subprocedures, etc.

------------------------------------------