Validation rules are checked in almost all cases. If you have a validation rule (a rule in Microsoft® SQL Server™) that says the Qty field must be greater than 5 or the DeliveryDate field must be later than the OrderDate field, you should keep it. Use either a trigger or a CHECK constraint in SQL Server to enforce field-level validation. The trigger offers the benefit of customizable error messages for violating the validation rules.