SQL Server Performance

Try Catch in SQL Server 2005

Discussion in 'Getting Started' started by lcerni, Aug 27, 2007.

  1. lcerni New Member

    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?
  2. lcerni New Member

Share This Page