Debug a Stored Procedure..!!

Question

Is there any method to Debug a Stored Procedure step by step?

Comments

I would strongly recommend you to read this post. I think you will find out your answers here.
http://www.diaryofaninja.com/blog/2010/11/23/debugging-sql-queries-function-amp-stored-procedures-with-sql-management-studio

Answer 1

add an input parameter named @Debug = 0 (defaulted to 0 = off) at the end of the parameter list for the procedure.

then add if (@Debug = 1) print '...';

statements in the code at key junctures to display any useful internal values etc.

Yes, it's "old school" and debuggers that let you "walk the code" are great - but this works for anyone from any SQL tool (including anyone debugging without your same IDE).