sql2008r2 sp4_SP2破坏了SQL2K存储过程调试

sql2008r2 sp4

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

有些人注意到将SP3应用于SQL Server 2000后，存储过程调试无法正常工作。如果遇到这种情况，诀窍是调用

exec sp_sdidebug "legacy_on" exec sp_sdidebug“旧版”

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.

这是SP3中添加的新安全开关，仅影响App调试。 另外，请注意该设置不会持久，并且每次启动SQL 2K Server时都需要调用它。

翻译自: https://www.hanselman.com/blog/sql2k-stored-procedure-debugging-broken-with-sp3

sql2008r2 sp4