How to debug store procedure through VS2005

Please select view and select server explorer, and connect database then select the procedure.

Then click the procedure and open it, then select the line and put the debug when you want to debugging. After that you select the procedure and right click and select option of ‘step into store procedure’.