did debugging with SP3 ever get fixed for Visual Studio.NET?

From: Les Caudle (very_at_tiredofspam.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 06:21:35 -0500

When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
from Visual Studio - single stepping into the stored procedure.

I spent a day trying to fix it maybe 8 months ago - and gave up.

Are there any tech notes that actually work to restore the ability to debug when
SQL Server is on the same machine as Visual Studio?

If not, can I fix the problem by un-installing SQL Server and then installing
the SP2 version? I'm unclear if the database files would have any problems with
this - or have any problems when moving SP2 databases to my SP3 production
boxes? 

--
Thanks in advance, Les Caudle

Relevant Pages

  • RE: Cannot break at stored procedures from VC.NET 2003
    ... How do you debug the stored procedures in Visual Studio .NET? ... Debug Stored Procedures in Visual Studio .NET ... And which database do you work on, is it SQL Server 2000 SP3? ...
    (microsoft.public.vsnet.debugging)
  • did debugging with sql server sp3 ever get fixed?
    ... When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures ... SQL Server is on the same machine as Visual Studio? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help: 900 byte limit on stored procedure parameter?
    ... stored procedures are working perfectly. ... for some odd reason when you use Visual Studio to view ... field using SQL Server Enterprise you see that the data really is ... I am able to cut and paste any size into this field through SQL ...
    (comp.databases.ms-sqlserver)
  • Re: Help: 900 byte limit on stored procedure parameter?
    ... I also found this problem of visual studio some time. ... stored procedures are working perfectly. ... I am able to cut and paste any size into this field through SQL ... 900 bytes through a strored procedure parameter. ...
    (comp.databases.ms-sqlserver)
  • Debug Stored Procedure
    ... Debug Stored Procedures in Visual Studio .NET and it states ... I have enabled SQL Server Debugging in the project. ...
    (microsoft.public.vsnet.debugging)