How to debug a stored procedure in sql server 2008

Question

I newly joined as a Trainee.. Can anybody help me?.. how to solve issues that raises in stored procedure. Any methods or techniques to find the bugs in a stored procedure..

Joginder Banger · Answer

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.

Manish Kumar Choudhary · Answer

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