The views expressed on this weblog are mine alone and do not necessarily reflect the views of my employer.
 Tuesday, February 18, 2003
SQL2K Stored Procedure Debugging broken with SP3

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

exec sp_sdidebug "legacy_on"

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.

 


Updated Link to this post 10:52:11 AM  #    comment []  trackback []