Error handling in SQL Server 2008 needs careful implementation. Here is the pattern the Microsoft "Oslo" Repository uses. It is based on experimentation and best practice guidance from the SQL Server team and other SQL Server experts.