The SP debugger works for me on WIN2KSP2 w/o any problem. Take a look at 'Transact-SQL Debugger' article, the 'TROUBLESHOOTING BEST PRACTICES' section in particular, from
http://support.microsoft.com/support/SQL/Content/2000Papers/Transact-SQL%20Debugger_White_Paper.asp.
>I get this error when every I try to debug a stored proceudre with the Query Analyzer on my workstation.
>
>
>Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1
>[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on SNARF (Error = 0x800706ba). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on KINETIK-XP. Debugging disabled for connection 59.
>
>
>SNARF is the name of my sql server and KINETIK-XP is the name of my workstation. I have made sure the SQLDBREG.EXE is installed on my workstation. How do I make sure its registered? I cant register the exe with regsvr32. I already tryed reinstalling the client tools and still get the same error.
>
>Any ideas? TIA
>
>Eric
--sb--