XP SP2 and Debugging SQL Server SPs via Query Analyzer
A couple of folks have reported this is a problem in the newsgroups, it is and I just posted this to .tools:
This is a known issue with WinXP SP2. A fix for this has shipped in hotfix 944 on 6/2/04. It shipped in 32-bit only originally. Any later hotfix for 32-bit or 64-bit also includes this due to the cumulative nature of our hotfixes.
We will be updating the following KB to reflect this:
BUG: SQL debugging does not work in Visual Studio .NET after you install ID: 839280
To get a hotfix you need to contact PSS.