posted on Thursday, July 21, 2005 5:12 AM by WhoIsKb

Stored Procedure Debugging

Yesterday I saw that one of my co-workers was connecting to SQL Server through Visual Studio and figured I would give it a try.  Normally I use query analyzer but I liked the idea of working with Sql Server within Visual Studio, but forgot you can do that.  As I was writing some stored procs and playing around with some data, I noticed an option on the context menu, "Step Into Stored Procedure" which allows you to debug and walk through stored procudures.  So I gave it a whirl, and man will this be a huge time saver.  You have all your normal debug windows available such as watches and auto so you can look at variables, which is a lot better than the print statements I used to use.

Comments

# re: Stored Procedure Debugging

Thursday, July 21, 2005 7:26 AM by Dave Balzer
This is a great tip. I have largely ignored the ability to connect through VS, but with the ability to debug I'm going to have to check this out.

# re: Stored Procedure Debugging

Thursday, July 21, 2005 8:26 AM by asaxton
I've used this feature a lot and I love. Sometimes it can be a pain to setup within the server, but once it's working it's awesome.

# re: Stored Procedure Debugging

Monday, July 25, 2005 3:26 AM by Mihir Solanki
Yes, Thats right ... its very usefull especially when there is a complex sql script. Same for Javascript debugging ... you can use all debugging related windows ...