Using Try-Catch Blocks to Handle T-SQL Errors

Bill Graziano has an article on using 'Try Catch' blocks in SQL Server 2005 and above to handle errors.