Debugging a stored procedure from Query Analyser can be very useful.
That is if you can get it to work.
It is sensitive to DCOM permission settings.
That is if you can get it to work.
It is sensitive to DCOM permission settings.
This is an article on how to setup the DCOM settings that will allow the SQL Server debugger to work.
Developer Rants 