Debugging stored procedures in Query Analyzer of MSSQL2000

Bottom line is that the DCOM configuration must include the tcp/ip protocol.

The debugger does not use the same connection as SQL Query Analyzer, which means that there is second connection for the debugger. It uses DCOM to make a connection to the server.

If you can't debug, run dcomcnfg, select the protocols tab, and make sure tcp/ip is in the list.