February 23, 2009 at 1:24 pm
I have SQL Server 2005 Enterprise Edition on a Windows Server 2003 server. I am trying to debug a stored procedure in Visual Studio 2005 but the option Step Into Stored procedure is not available.
It is not a permissions issue as I have tried a couple of logins with different rights could it be my version of Visual Studio - I don't think it is the Pro copy - or is it something else?
Very frustrating - the rest of the box is working fine.
February 23, 2009 at 2:06 pm
This version of VS2005/8 is called premier partner edition generally known as BIDS it can only be used to do BI(business intelligence) development. If you want to develop databases and debug you need to buy VS2005/8 Team Suites or Database developer edition.
And in VS2005 Team Suites you need a separate download to run the Team Database developer edition.
Kind regards,
Gift Peddie
February 24, 2009 at 6:49 am
To check which version of VS you have installed click Help-->About. You can then click Copy Info and post your version information here. If you have:
Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727 SP2
Installed Edition: IDE Standard
Microsoft Visual Studio 2005 Tools for Applications 77633-163-9000041-41539
Microsoft Visual Studio 2005 Tools for Applications
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.3042.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.3042.00
Then as stated above, you have the wrong edition to do debugging.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
September 16, 2009 at 7:10 am
I have Visual Studio Team System 2008 Development Edition and the "Step into" option is not available. You mentioned there is a seperate download. Where might I find it?
September 16, 2009 at 7:23 am
Unfortunately this option is missing. Trick is to set a break point into your CLR procedure and hit F10 (step over) in your test.sql.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply