none
debug the sp

    Question

  • Hi Team,

     

    How can we Debug the Storedprocedure in SQL SERVER 2008 R2 please suggest me

    im new Dev activity.

    Thanks


    subu
    Wednesday, October 19, 2011 7:23 AM

All replies

  • Hi First Of All Write a clause that executes your sp like this: Exec [Your_SP] @Param1,@Param2,... Then click on the run button on studio and when debugger run click on step into button, then you are there!
    Regards Ahmad
    Wednesday, October 19, 2011 7:35 AM
  • Hi Team,

    As per your suggest i did it is taking a long time.

    Previouly we press F8 or F9 it is debugging right

    right now it is not working

    is there any other shortcut please suggest me


    subu
    Wednesday, October 19, 2011 7:55 AM
  • I personally Prefer the Profiler. so I started on this database and execute the procedure then Stop the trace, you'll see all the queries with the passed parameters so you can debug it
    Wagdy Ishac www.sqldair.com
    Wednesday, October 19, 2011 8:22 AM