Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DesertDude
Starting Member
8 Posts |
 Posted - 2010-06-07 : 16:26:54
|
| I have found a ton of articles on this topic, but not a one of them has helped me get to the point where I can actually debug a stored procedure in VS 2008. Please do not send me links to articles!! They describe options that don't exist, menu commands that are not there, and generally always lead me down the wrong path. It's amazing how much junk there is out there! I have a Windows app in VS2008 that is connected to a SQL Server 2008 database. I want to debug a stored procedure called from the application. I need to step into it from the app to see the values of the parameters that are being passed to it from the app. I am looking for someone who has accomplished this. Will you please tell me how to set things up in VS2008 so that I can do this?Thank you! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-07 : 16:39:36
|
| Have you tried these yet:http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=339http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=351To my knowledge the T-SQL debugger is not designed to interact with applications like you describe, and I'm pretty sure the Visual Studio debugger won't work that way either. Might be worth posting a comment on those articles to see if Buck has any suggestions.You can certainly use the T-SQL debugger and manually set the values you want to test/debug. The procedure will run the same way regardless of where the parameters come from. |
 |
|
|
DesertDude
Starting Member
8 Posts |
Posted - 2010-06-07 : 17:05:12
|
| I know you can debug a sp from vs because I've seen it done. I've tried debugging just the sp as you mention. That didn't help in my situation. I have to see what it's getting from the app. The app shows that it is passing the right value and when I run the sp with that value it works, but when the two run together it fails. I have to see what the sp is receiving. That's where the clues seem to be pointing. But thanks anyway. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How to debug SP in VS 2008???