HOW TO DEBUG A STORED PROCEDURE IN SQL SERVER 2005
My manager has told me this when i am facing some issues in a stored
procedure on a DEMO day.I would like to thank him for the same.
Go to Visual Studio –> Open SERVER Explorer –> Add Data
Connection –> SELECT you data base –> Right Click your SP
–> Select STEP IN Stored Procedure.
Use F10 to degug.
Share Knowledge.We all are here to learn.