I also prefer optimistic buffering, but it depends on the business requirements.

It's trappable with ON ERROR if SET REPROCESS is set to something like 1. I don't know if TRY...CATCH would also work.

>No, it's better to have buffering 5.
>
>AFAIK the error message you're getting is untrappable.