Report on data in SQL database that does not meet certain rules
If you're going to maintain some sort of flag indicating which rows have problems (which makes sense if you have a lot of rows, 99.9%+ of which will be fine), then I'd use a trigger to check for the conditions. That way there's one check, only done when a row is actually added or changed.