David, I'm certainly intrested to see the declaration of that SP.

Has anyone measured the performance cost of either of these techniques (Steve's CLR using a seperate transaction context and David's approach to use ADO) ?

This probably won't be that critical if they are restricted to pure exception handling, but it's another situation if this would be used for more general logging purposes.