Nice article.  It's just too bad that there is a need for it.

<Rant On>

Error handling in SQL Server 2000 is utterly brain-dead.  Whenever I can, I prefer to code in DMO/ADO just to avoid this "little" issue, and the equally brain-dead SQL debugger.  Unfortunately, the DMO work-around is often inadequate or too slow, forcing my hand to use kludges like this.  T-SQL programming involves a major loss of productivity, compared to any other modern language I know of.

<Rant off>