am trying to use the Query Analyzer debugger. I've never gotten this to work properly. I've always just written temp output statements - stored results to table etc. But it would be nice to get this to work.
This is with sql server 2000, sp3.

Knowledge base articles tell me that I need to do the following:

1) grant execute permission to the sp: sp_sdidebug

2) execute sp_sdidebug 'legacy_on' (in win2k - sp3)

3) in dcomcnfg: setup permissions so 'everyone' and the system account have permissions
4) run sql server as an administrative user - not system account

I did 1 through 4. with these steps I can get the debugger to run the sp's... but.. it doesn't stop and execute a line at a time - it just runs through the sp and completes it without stopping - even when I set breakpoints

Does anyone have any experience with the sql debugger?

Thanks,
David Schlesinger