>Is there a simple approach of debugging a stored procedure? When I am running an ASP.NET app I want to see if certain IF conditions were met and the code after the IF was executed. One simple way I am thinking is if I can create some kind of token or semaphore file that I can look at (after the procedure) is done? How do you do it?

I don't know if you have access to VS 2012 but web debugging capabilities are dramatically improved. Google "VS 2012 Page Inspector."