>Hi,
>How to enable debugger in SQL Server 2000? I have executed command
>Exec sp_sdidebug 'legacy_on' using sa then only select debug from my stored procedure, but SQL Server still complaint as the following:
>
>Server: Msg 514, Level 16, State 1, Procedure sp_sdidebug, Line 1
>[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to communicate with debugger on EHTAN (Error = 0x80070005). Debugging disabled for connection 56.
>
>Any ideas?

the way I debug my SP's

From QA, Rt click on SP in list. Bottom option is debug. Input form will allow you to create all the params inbound to check. Fill them in and continue into the SP.

You can also swing in through .NET :)

__Stephen