I have a procedure that is like a driving/main procedure and it calls several procedures within it. I am interested in knowing if one wants to use try catch do you place the try catch in the main procedure or do you place it in the individual procedures that the main procedure calls. If one of the call procedures fail everything rolls back. I have tried coding it in the main procedure and I have tried coding it in the procedures that it calls and I have not gotten it to work. I am beginning to think that try catch is not going to work and that I should go back to using returns and outputs. Can anyone provide a good web page to look at a good example?
Just to let people know... I found this web site: http://technet.microsoft.com/en-us/library/ms179296.aspx It has helped me tremendously. I found an example that works for my situation.
