Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Unanswered: How to step trough procedure in Debugger

    I want to debug a procedure in Query analyzer. When I open the T-SQL debugger and add all the passing parameters the debugger runs very fast and the message shows "@RETURN_VALUE = 0".

    How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.

    Please help.

    Thanks

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Exclamation Re: How to step trough procedure in Debugger

    Q1 How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.
    A1 First, make sure debugger support was installed on your development Sql Server. (What you are describing may be a dev workstation with VB / VStudio installed running against a dev server that does not have debugging support installed?)

    Note: It is advisable NOT to run the dubugger against a production server. The debugger can be very resource intensive (especially with regard to locked resources) and the debugger is NOT bug free.

    A link to more information:
    http://support.microsoft.com/default...b;EN-US;310650

  3. #3
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    SQL Server service must be logged on as non-System account:
    Configure DCOM:
    run dcomcnfg.exe
    check DCOM settings (App.name is sqldbgreg)

    For more see BOL "Troubleshooting the Transact-SQL Debugger" topic

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •