did debugging with sql server sp3 ever get fixed?

  • Thread starter Thread starter Les Caudle
  • Start date Start date
L

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?
 
Les said:
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?
Click to expand...

you need to execute:
Exec sp_sdidebug 'legacy_on'
 
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
 
Back
Top