Debugging Stored Procedure

  • how to Debug Stored Procedure in ms sql server 2008

  • first edit your execute statement, e.g.:

    exec yourSP @Parm1='V1',@Parm2='v2'

    then click the green arrow button or debug->start debugging menu, the press F11 to step into the SP.

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

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