there are 2 possible solutions for this problem.

1. Install SP# for SQL Server 2000.

or

2. Configure ur server using "server N/W Utility" by disableing all other protocols other than TCP/IP

hope...

deselles,

Thnaks. debug is working now. i have just installed SP3 on Client & Server and thats all it started working..

Pratap

Tim and deselles

thanks for ur replys.

tim,

i am alo following the same steps as you have mentioned. and for me it is failing on step (D). it is not pausing...

Andrew,

In Query Analyzer 8.00.194 we a feature to debug a Stored Procedure.

Tim,

thanks for ur reply. my problem is it is not getting into pause mode. The SP is getting executed...

Thanks John Zacharkan,solart for the information.

i am using SQL Server 2000. Log Explorer trail version supports only pubs and northwind databases only. with out using tool can't we do...