You must Sign In to post a response.
  • Category: SQL Server

    How to debug stored procedure in sql server?

    How to debug stored procedure in sql server?
    Please explain.
  • #763624
    Hi rajesh,

    After create your procedure just exec that like below

    exec procname @i=5;


    and put breakpoint behind that and Click on Debug (Green button) in Toolbar, once you click on debug same like visual studio the break point will trigger and do the next actions when you press F11 on your keyboard.

    I will share you the images for the same, please check those.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

    Delete Attachment

  • #763627
    Thank u.


Sign In to post your comments