Is this the same question as on SQL Server Performance.com?
http://www.sommarskog.se/error-handling-II.html
http://www.sommarskog.se/error-handling-I.html
offer a good insight on error handling.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]