did debugging with sql server sp3 ever get fixed?

[Les Caudle]

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?

 

[TomislaW]

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?

you need to execute:
Exec sp_sdidebug 'legacy_on'

 

[Les Caudle]

I had already done sp_sdidebug 'legacy_on' .

I wish it were that simple. I spent a day reading tech notes on this many
months ago.

VS.NET no longer allows me to debug. I get no errors at all, I just can't single
step into a stored procedure like before.

Regards, Les Caudle