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

    How to debug stored procedure in sqlserver

    iam using sqlserver 2008 but iam unable to work with debug in stored procedure.

    when iam clicking debug button that will be giving alert message like


    it is not working sqlserver 2005 and its earlier versions.
  • #762129
    Hi

    For debugging stored procedures in sql sever 2005 there is good article in the below link.

    http://www.dotnetfunda.com/articles/show/27/debugging-stored-procedures-in-sql-server-2005

    Below are some references on it.

    https://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/435c0c43-571a-442d-9fb9-f3f495b1f2ed/how-to-debug-stored-procedure-in-sql-server-2005?forum=transactsql

    Regards,

    Sridhar Thota.

    Sridhar Thota.
    Editor: DNS Forum.

  • #762130
    Hi dineshkumar,

    I guess this link will be helpful to you.

    http://www.dotnetfunda.com/articles/show/27/debugging-stored-procedures-in-sql-server-2005

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

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

  • #762138
    Hello Dinesh Kumar,

    Go through the below link for reference :

    http://www.dotnetfunda.com/articles/show/27/debugging-stored-procedures-in-sql-server-2005

    http://www.4guysfromrolla.com/articles/051607-1.aspx

    http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

    http://www.codeproject.com/Articles/30573/SQL-Stored-Procedure-Debugging-Using-Visual-Studio


    Hope this will help you.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #762147
    please find attached image

    Delete Attachment


Sign In to post your comments