Hai .....,
I 'm able to debug a Stored Procedure directly on the server, but I 'm not able to debug the same stored procedure from my machine. What should i do in order to debug the stored procedures on the server from my workstation.
(I can debug the stored procedures of my local sql server)
Please take a look at the "Troubleshooting the Transact-SQL Debugger" topic in BOL. The url is below:mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\trblsql.chm::/tr_servtools_5cfm.htm
There are also additional KB articles that you can find in Technet on this topic.|||Hello Umachandran,
The Sql Server 2000 (on the server SP3 is not installed) runs on Win XP. Using the help file address that you have given me, I made the following adjustment but still the cursor does not wait on the first statement, Instead it waits for some time (Displaying wait for user input in the status bar) and returns with @.RETURN_VALUE = 0. I have did the following adjustment;
Start -> Run -> dcomcnfg -> Component Services -> Computers -> My Computer -> DCOM Config -> sqldbreg -> Right clicked and selected properties -> Security Tab and for Access Permission -> Edit -> Added System and Everyone and gave them both Local and Remote Access. Still no luck. 
Any other suggestion|||Please take a look at the KB article below
http://support.microsoft.com/default.aspx?scid=kb;en-us;280101
This has additional information than BOL. You should also try this from a different client so you can start with a default configuration and see.
