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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham