VSLive and Debugging Sprocs
Well, I'm at VSLive! San Francisco today doing a pre-con with Ken Getz called Build a .NET App in a Day. I'm really amazed at the number of people who are new to .NET.
During the workshop we have a section on ADO.NET with SQL Server. Ken then gets the bright idea that we should show T-SQL debugging from within Visual Studio .NET 2003. But of course, we've got SP3a installed on SQL Server so debugging is now turned off by default. So I had to run sp_sdidebug to fix debugging. Here's a link to the KB article if you want more info [0].
End of line.
[0] http://support.microsoft.com/default.aspx?scid=kb;EN-US;328151