debugging stored proc: can't step into

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Timo (timo_at_anonymous.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 13:07:54 -0400

I'm using VS.NET 2003 Enterprise Developer in SQL-stored proc debug mode for
the first time and am not having much success stepping through the SP in
"standalone mode" when following these instructions:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;316549

I open the Server Explorer, navigate to the SP, right click,and choose Step
Into... I provide the necessary input values in the popup dialog window.
Several breakpoints have been set in the SP. Execution stops at the first
breakpoint, but when I press F11, the program (which has half a dozen
blocks) finishes and I get this success message in the Output window:

The program 'SQL Debugger: T-SQL' has exited with code 0 (0x0).

SQL Debugging has been enabled in the Project Properties on the Debugging
page.

I don't understand what's going on. Does this standalone debug feature work,
or do I have to debug the SP by stepping through from managed code?

Thanks
Timo

Relevant Pages

  • Re: Reverse comma operator?
    ... If you write it properly the first time (so ... it makes logic errors that much easier to spot. ... Debugging is twice as hard as writing the code in the first place. ... Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. ...
    (comp.lang.c)
  • Re: Disc lock up on 8.0-STABLE
    ... I am not sure that ym debug kernel will help now - assuming this is the ... Was yoour system a fresh install, or an upgrade from ... the first time it happened was about 10-14 days ago, ... I had to enter reboot like 30 times before the box rebooted. ...
    (freebsd-stable)
  • debug builds needing VS DLLs
    ... I've been working with Visual Studio for quite some time, ... today I ran into something surprising for the first time. ... I compiled a small command-line executable in Debug mode and sent it ...
    (microsoft.public.vc.ide_general)
  • Re: Keyboard freezes afterboot
    ... > but that seems like overkill. ... Really, to debug this, we'd need to see the ... It's the first time I see a problem like this, ... said, I don't see any timeout, conflict or strange error. ...
    (comp.unix.bsd.netbsd.misc)
  • Re: Determine if program is running in Visual Studio IDE
    ... > IDE/debugger as opposed to standalone? ... We often include support files in the ... want to find out than checking the 'DEBUG' constant. ...
    (microsoft.public.dotnet.languages.vb)