>Bob, I plan to have the business logic be the primary enforcer of this rule, but I also wanted to enforce it at the database level. So would the best way to "fail" the update be to make the trigger throw an exception?
>
In my opinion - yes, it's better to do on the database level in addition to front-end.
If it's not broken, fix it until it is.
My Blog 
