You must Sign In to post a response.
  • Category: Smart Devices

    To debug the stored procedure


    plz gv ans "how we will debug the stored procedure steps".

  • #710993
    which version of sql server you are using?
    You want to debug SP in sql server or in some other tool?
    If you want to debug it in SQL Server 2005 and newer version then follow link. Everything is given here.

    Dharmendra Kumar

  • #710994

    When you need to debug a stored procedure, you only have to locate it in the database explorer — Step-in and step-over command and is available from the debug menu. Optionally, start debugging from a stored routine source window, or from the Code toolbar.

    Once you have the object browser top menu, select a stored procedure in a database and click on the debug option in top menu. Select the start debugging option and debug the stored procedure.

    Refer this link also,


  • #710995
    Goto SQL Server management Studiko-> Goto Object Explorer-> Click on the server (or may be your local machine)->Select Database-> Select Programmability-> C lick on Storedprocedures-> Right click on the particular Storedprocedure for instance "sp_EmployeeDetails". Select Debug Procedure
    If the storedproceudre has any input parameters, the the Debug Procedure dialog box will be appearing, with a table containing column for the input parameters list and the other for value for those input parameters Enter values for each parameter, and click OK.


    Have a good Day

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.