Nice QoTD :-).

An important point to remember is that a TRY..CATCH can be used to catch all database errors having the error number >10 that do not terminate a database connection.

MSDN has more information on this.

http://msdn.microsoft.com/en-us/library/ms175976.aspx