Friday, February 17, 2012

Debugger help

Could anyone please give me a quick head start on the debugger in SQL Query
Analyzer. I right click on my 'sp' and select debug. This shows my code in
the right pane. However I seem unable to step though. The only buttons
highlighted are 'Go' and the 2 breakpoint buttons. Only when I click 'go' d
o
the step through, step over, etc buttons become highlighted by which time it
is too late as my sp is already processing.Set a breakpoint at the beginning of the procedure then click 'Go'.
ML|||Hi
I think that if you click on the procedure declaration your buttons should
become active.
John
"Chubbly Geezer" wrote:

> Could anyone please give me a quick head start on the debugger in SQL Quer
y
> Analyzer. I right click on my 'sp' and select debug. This shows my code
in
> the right pane. However I seem unable to step though. The only buttons
> highlighted are 'Go' and the 2 breakpoint buttons. Only when I click 'go'
do
> the step through, step over, etc buttons become highlighted by which time
it
> is too late as my sp is already processing.

No comments:

Post a Comment