How to debug a stored procedure in sql server 2008

first of all make a store procedure well format. if you want debug the store procedure then just select the store procedure like this way.


create proc procedureName
()
as 
begin


end


if you want debug any store procedure select the procedureName and press the CTRL+F5. your studio convert to in debug. 

Go through following links it will help you

https://msdn.microsoft.com/en-US/library/yet1b7by%28v=vs.80%29.aspx

http://stackoverflow.com/questions/1793612/debugging-stored-procedure-in-sql-server-2008