if you are using SQL Server 2000, you can use its Query Analyzer to debug stored procedures1. Open Query Analyzer
2. If the Object browser pane is not visible, press F8
3. In the Object browser, find your stored procedure
4. Right-click the SP, click Debug
2. If the Object browser pane is not visible, press F8
3. In the Object browser, find your stored procedure
4. Right-click the SP, click Debug
what's meaning?thank you !!!
Troubleshooting the Transact-SQL Debugger
http://msdn.microsoft.com/library/en-us/trblsql/tr_servtools_5cfm.asp?frame=true