Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Can't get sql server debugger to execute one line at a time
Versions des environnements
Network:
Windows 2000 Server
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement