Can you give us example of checks that you are carrying out?basic checks should be enforced through CHECK,unique,null or not null,data type etc.

Everything else I would validate through front end.but once again I don't know what you are trying to do...