We will look into creating a full blown generic error handling routine for T-SQL stored procedures using SQL Server Denali  T-SQL error handling features. This not only includes logging of all kinds of information, but also the creation of call chains and full error propagation as well.