Post reply

Debug the Stored Procedure

  • November 24, 2005 at 3:34 am

    #90032

    Hi,

    How to debug the stored procedure line by line.

    Seeing the error message and correct the error. or any other way to debug the stored procedure.

    Thanks and Regards.

    Thirumalaraj.

  • November 24, 2005 at 6:12 am

    #605683

    it might be nice to actually see the Stored procedure you're wanting help debugging

  • November 24, 2005 at 12:03 pm

    #605748

    I'm not sure if this is what you are looking for, but query analyzer has the option to debug a sproc. Right click on the sproc name, choose debug (I believe, I don't have QA open in front of me to verify). The system will then collect any necessary parameters and drop you into a debug interface where you can step through the query.

  • November 27, 2005 at 9:54 am

    #605983

    Also, try double clicking on the message line in QA where it tells you that you have an error. i.e. -- "line missing )". If you double click anywhere on this line of text, the cursor will then appear on the line that is missing the ')'. One drawback, if there is an error in your SELECT statement, it will just take you to the SELECT statement instead of where the error is located.

  • November 30, 2005 at 11:25 am

    #606824

    Tim was close - a search revealed this link:

    http://www.internet.com/icom_cgi/print/print.cgi?url=http://www.15seconds.com/issue/050106.htm

    i need to resolve permissions issues when i try doing this but it shows promise

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply