First time here? Check out the site's "greatest hits" or read a post from the archives. Feel free to leave a comment or ask a question, and consider subscribing to the latest posts via RSS or e-mail. Thanks for visiting!
« My Collection of .NET Regular Expression... | Main | BBSs, Dead OSs, and Door Games »

SQL2K Stored Procedure Debugging broken with SP3

Posted in Web Services | Bugs

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.

 



Tuesday, February 18, 2003 11:49:45 AM (Pacific Standard Time, UTC-08:00)
Scott, thanks for the heads-up? I just sent a message to DM's CLR list right before reading your entry in NewsGator. Argh! My question was slightly different -- i can debug, but when I stop debugging (either detaching or closing the debugging session), SQL Server terminates. Do you know if this is a problem related to SP3, or just the VS.NET debugger attaching invasively? Thanks!

John St. Clair
Friday, July 29, 2005 1:50:35 PM (Pacific Standard Time, UTC-08:00)
John or Scott, did either of you get a resolution to this?
FYI: SP3a turned this off due to RPC restrictions for the Slammer Virus.

Eddy White
Eddy White
Comments are closed.

Contact

  • Scott Hanselman

Sponsors

SyncBackSE from 2BrightSparks

Hosting By

Dedicated Windows Server Hosting by ORCS Web

On this page...

Tags

Africa (67) ASP.NET (579) ASP.NET Dynamic Data (8) ASP.NET MVC (33) BabySmash (15) Back to Basics (9) Bugs (168) CodeRush (21) Coding4Fun (37) Corillian (26) DasBlog (129) DevCenter (1) DevDays (5) Diabetes (60) DLR (1) eFinance (14) Gaming (112) HttpHandler (16) HttpModule (21) Identity (3) IIS (9) INETA (8) Internationalization (41) IOC (1) Javascript (65) Learning .NET (96) LINQ (16) Longhorn (11) Microsoft (68) Mix (9) Movies (44) MSBuild (1) Musings (474) Nant (39) NCover (12) NDC (11) NDoc (6) NotNorthwind (2) NUnit (46) PDC (55) PHP (2) Podcast (141) PowerShell (59) Programming (225) Python (1) Reviews (124) Ruby (61) Screencasts (20) Silverlight (25) Source Code (43) Speaking (185) Subversion (14) TechEd (122) Thabo (3) Tools (391) VB (6) ViewState (19) Vista (2) Watir (21) Web Services (427) Windows Client (25) WPF (19) XML (289) XmlSerializer (31) Zenzo (38)

Calendar

<October 2008>
SunMonTueWedThuFriSat
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
Posts in timeline
Posts in Large Calendar

Archives

October, 2008 (3)
September, 2008 (16)
August, 2008 (14)
July, 2008 (25)
June, 2008 (19)
May, 2008 (17)
April, 2008 (17)
March, 2008 (26)
February, 2008 (21)
January, 2008 (28)
December, 2007 (19)
November, 2007 (17)
October, 2007 (31)
September, 2007 (39)
August, 2007 (37)
July, 2007 (43)
June, 2007 (37)
May, 2007 (32)
April, 2007 (38)
March, 2007 (29)
February, 2007 (46)
January, 2007 (31)
December, 2006 (27)
November, 2006 (31)
October, 2006 (32)
September, 2006 (39)
August, 2006 (34)
July, 2006 (40)
June, 2006 (18)
May, 2006 (31)
April, 2006 (34)
March, 2006 (30)
February, 2006 (38)
January, 2006 (44)
December, 2005 (19)
November, 2005 (34)
October, 2005 (24)
September, 2005 (37)
August, 2005 (20)
July, 2005 (24)
June, 2005 (33)
May, 2005 (16)
April, 2005 (22)
March, 2005 (34)
February, 2005 (15)
January, 2005 (37)
December, 2004 (28)
November, 2004 (30)
October, 2004 (34)
September, 2004 (22)
August, 2004 (34)
July, 2004 (18)
June, 2004 (64)
May, 2004 (49)
April, 2004 (21)
March, 2004 (29)
February, 2004 (29)
January, 2004 (36)
December, 2003 (25)
November, 2003 (24)
October, 2003 (59)
September, 2003 (42)
August, 2003 (24)
July, 2003 (44)
June, 2003 (29)
May, 2003 (21)
April, 2003 (30)
March, 2003 (27)
February, 2003 (47)
January, 2003 (50)
December, 2002 (31)
November, 2002 (38)
October, 2002 (44)
September, 2002 (15)
May, 2002 (2)
April, 2002 (4)

Google Ads