Louis-644449,

First of all, I should have made more clear that an AFTER trigger is always an option.

I agree that triggers allow for more friendly error messages.

I think the technique I outlines is good for situations where triggers are not desirable. Some organizations simply don't like triggers.

-Dan