If you are using SQL Server 2008 then you can directly debug it using green triangle button available in toolbar.

In Query Analyzer window, write the line - EXECUTE <ProcName> <Param1,Param2.....> and click on that button. It will bring focus on this line then keep pressing F11 or use toolbar