I'm curious how other people do this? Do you query the @@Error global variable? Do you use structured exception handling? What kind of logging do you do? Et cetera.

As a PHP programmer, i handle all my DB errors using the PDO exception handler. I find it handy to extend the exception class and take it one step further by emailing me details of the error with high priority, then displaying a soft error message to the user.