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 |
|
rsheppick
Starting Member
5 Posts |
 Posted - 2008-08-18 : 13:55:51
|
| Greetings!I have been trying to setup the ability to debug my procs ect through visual studio 2005. however I right click on the sprocs and I have no "debug" option.I started reading this [url]http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005[/url]Went through the Microsoft website to setup debugging, but I had previously followed these steps.I'm usingMicrosoft Visual Studio 2005Version 8.0.50727.762 (SP.050727-7600)Microsoft .NET FrameworkVersion 2.0.50727 SP1Installed Edition: IDE StandardMicrosoft Visual Studio 2005 Premier Partner Edition - ENU Service Pack 1 (KB926601) SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 9.00.1399.00SQL Server Integration Services Microsoft SQL Server Integration Services DesignerVersion 9.00.1399.00SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 9.00.1399.00 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-08-18 : 16:10:11
|
| Only certain editions of Visual studio allow you to debug SQL Server Stored procedures(NOT SQL EXPRESS). Referance Microsoft to ensure your version of visual studio allows for this. |
 |
|
|
rsheppick
Starting Member
5 Posts |
Posted - 2008-08-18 : 17:31:34
|
| I did, according to what I was reading VS 2005 Partner Edition does all of it, and this is also running on 2005 SQL server standard. |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
|
|
|
|
|
Debugging 2005 SQL with Visual Studio