Post reply

How to debug stored procedure in Express version

  • October 7, 2006 at 11:03 am

    #114685

    Hi there,

    Is there anyone know how to debug a stored procedure in MS SQL Server Management Studio Express version? I've the problem to debug my stored procedure. Please help!

    Many thanks,

    AC

  • October 8, 2006 at 4:57 pm

    #664735

    I don't use debuggers in SQL Server... just the ol' Mil Spec Mark I Mod I Eyeball.  Probably not what you wanted to hear, though...

    What are you trying to debug (ie. Post the code and the error/problem)?  I'll just be we can help

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 20, 2006 at 6:19 pm

    #667236

    Thanks Jeff for your response and intention of trying to help. It is not a serious matter, I am just trying to learn SQL Server 2005 in my own time. I used to develop stored procedure in SQL 2000, just wanted to see what is the improvement of this version. There is no one answer this question anyway.

    Thanks,

    AC

Viewing 3 posts - 1 through 2 (of 2 total)

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