How do you do Error handling (especially SQL) in an ASP.NET project right

Question

I have a another ASP.Net web project that I am working and I have approached error handling from different angles. I was just wondering if any seasoned and experienced developers out there had any recommendations.

Bonus points for discussions on a nice logging framework for ASP.net:)

Answer 1

I've used the ELMAH, (Error Logging Modules and Handlers) is an application-wide error logging facility that is completely pluggable, on several projects and it works great: http://code.google.com/p/elmah/

I've also used the built in Health Monitoring in ASP.NET 2.0: http://msdn.microsoft.com/en-us/library/ms998306.aspx