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
>

Developer and DTS rights

To adhere to corporate security policies we have removed the guest
account from msdb. This has resulted in developers not having the
ability to view any dts packages on the server. We have multiple
development groups and a large amount of databases on the server.
Does anyone have a solution to this situation that we could use?
Thanks in advance, Markassign a security group a login to the sql server,
grant dbaccess to the msdb database for that user.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Mark Anderson" <magnm01@.wellsfargo.com> wrote in message
news:ac3d559a.0401141350.68879fa9@.posting.google.com...
> To adhere to corporate security policies we have removed the guest
> account from msdb. This has resulted in developers not having the
> ability to view any dts packages on the server. We have multiple
> development groups and a large amount of databases on the server.
> Does anyone have a solution to this situation that we could use?
> Thanks in advance, Mark