On 13 Mar 2006 at 17:04, dbagregc wrote:

>One thing many of these "consultants"
>like to do is put data in to our database outside of the means we
>provide them. This almost always leads to an eventual support call
>from the customer saying that our program is not working and its our
>fault, whereas in actuality it is most likely their "consultant's"
>fault for putting in bad data because they thought they knew what they
>were doing.
>
>vendors software? If not do you guys have any other suggestions,
>because we DESPERATELY NEED INTEGRITY!

What do you mean "bad data"? What kind of "bad data" the
consultants used to put into your DB?
And main question: did you set up referential integrity in your DB?
Check constraints?

--
SY, Dimitry Sibiryakov.