Debug tsql

I tried to debug a procedure from query analyzer, but i could not able to step in or step out.
only few actions i could able to perform on the code,like execution,set break points.
step in and step out is not enabled.Is there any option to enable it..There is no "debug" of stored procs or in query analyzer. You will need to cut it down, exectue it line by line and use print statements, etc to see what is going on.

Are you getting an error?

If you post the stored proc here, someone might help you.|||

>>There is no "debug" of stored procs or in query analyzer

Are you sure?
Hit F8 this will open up the Object Browser, navigate to the proc, right click on the proc and select debug

Denis the SQL Menace
http://sqlservercode.blogspot.com/

|||I do not have a debug option on mine. Maybe you have the .NET development installed that gives you that?

Also, I might be wrong, but I think he said in one of the prior questions, he was using SQL 2000.|||

I am talking about query analyzer (SQL 2000)

Here I took a screen shot of it

http://tinypic.com/view/?pic=44hvq7a

Right click on the procedure and the last thing in the menu should be debug

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Ohhhh. You are correct. I had never tried that method.

That does give a simple debugger version that might do what he wants.|||Even if you were wrong about the existance of the debugger, I far prefer your original technique :)|||what is the solution for my problem..