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.

Pawan Kumar

Pawankkmr@hotmail.com

Advertisements