Hello all. I posted this in the SQL Server and Visual Studio groups and got no joy. Hoping some of you have come across this problem. I have the pro version of Visual Studio.net 2003. It comes with the SQL server 2000 Developer edition. If I install the SQL Server dev edition, the VS IDE does not allow for debugging stored procs that are on the dev SQL server. The options for stepping into and all debugging options are just not there.
Now if I install MSDE 2000 as a named instance, the IDE will allow me to step and debug but only on the MSDE instance. It simply will not allow me to debug the dev edition. I've tried reinstalling, applying SP3 and then tried SP4 all brought no joy. Anybody with some insight here would be appreciated.
Thanks
T-SQL Debugging in VS2005
Hot Topic
- new vspackage wizard
- Button Style Trigger - IsPressed Property
- ServerDocument.AddCustomization() starts new Word Instance
- aspnet_compiler exiting with error code
- DLinq's way to "SELECT TOP"
- The report definition for report 'xxx' has not been specified
- Where can i get the full setup of the WCF sdk november 2005 release.
- Issue with DSL Tool
- VS Team Test extensible to support alternate languages?
- The Ultimate VSTO Outlook deployment package
Visual Studio
- Can you build a guidance package in VB?
- WCF distributed transactions without sessions?
- where's vss 2005 in vsts 2005?
- Opening multiple VSTO enabled WordML docs
- How to Sort a Group Dynamically
- Webcam preview in an Avalon app
- Special Installation
- Adding menus items (don't understand ProvideMenuResourceAttribute)
- CodeDomProvider questions
- Revisions in Bookmarks
T-SQL Debugging in VS2005
Aquilegia
Hello,
Sorry that you didn’t manage to find an answer from the other forums. The scenario that you are describing is the correct behavior.
Visual Studio 2003 Pro can not debug against a full SQL Server install (e.g. Developer). It can however debug against MSDE which is a cut down version of SQL.
If you would like to debug against a full SQL Server then you would need to buy a higher SKU of Visual Studio such as Enterprise or Architect.
Regards
Richard Cook
Visual Studio Debugger QA