Or use Michael's TRY-CATCH technique but write a row to a log file instead of sending an email. I know some DBAs frown on using the email function.