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

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 CaudleWe can get it to single step through the procedure, but not set a breakpoint.
Was it ever possible to breakpoint? I note the documentation states it will
not "Break", but we took that to mean one could not break the execution and
re-start.
Cheers
Happy Harry
"Les Caudle" wrote:
> 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
>

develop RS2000 report through V Studio.NET 2005

Hi all, is it possible to create RS2000 format reports through Visual Studio
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>