I have try this. When I press F5, the step button just flash (enabled and disable again in one second). The running of SP finished in one second and never stop.
The SP I want debug is sp_Monitor_Capture_DB_Space_Info I got from
http://www.sqlservercentral.com/.
I also try other SP. The step button just work fine.
I wonder if any kind of code in that SP to cause this problem. In other words, if some kind of code, the debugger can't debug.
Thanks
Jim