Whether you want to Edit, Debug or Run stored procedure or function, just right click and select from the context menu. Alternatively, you can double click and stored procedure or function will open up.