November 20, 2008 at 8:18 am
What's the best way of debugging a stored procedure, I have a really long stored proc. Thanks!
November 20, 2008 at 9:06 am
In the upper right hand corner of this page is a window labeled "Search", may I suggest you input "Debug T-SQL" and then click on the Go button. If after having done that and reading the articles and forum posts returned, read the article in my signature block and then you may want to repost with a more specific question about why a certain portion of your procedure does not work.
November 20, 2008 at 9:18 am
If you have a Visual Studio installed on your PC you can use it to debug stored procedures, it offers a very good way of debugging them.
November 20, 2008 at 11:26 am
As mentioned Visual Studio is a great tool for debugging SP.
November 20, 2008 at 11:33 am
Visual studio works gret, if you have the Professional Version or greater. Standard Edition doesn't do it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply