Some folks have noticed that Stored Procedure Debugging was not working after applying SP3 to SQL Server 2000. If you run into this, the trick is to call
This is a new security switch that was added in SP3 and only affects App Debugging. Also, note that the setting doesn't stick, and you'll need to call it each time you start up the SQL 2K Server.
Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant, father, diabetic, and Microsoft employee. I am a failed stand-up comic, a cornrower, and a book author.
Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.