My suggestion would be to learn more about how to use integrity checker safely.  I know I should run it on our database regularly but I don't know enough about it to be sure I'm not going to mess up something. 

 Thanks for providing this resource it's  very helpful!!

Hi there

You should certainly run the Integrity Checker regularly in "Tell me about issues" mode to see what it reports back to you.  It is then necessary to consider each reported issue on a case-by-case basis, with someone who knows what they all mean.  Usually this is your friendly local SalesLogix Business Partner!

Some of the detault "Repair" options if you run it in "Fix" mode are a little too aggressive, so it is not wise to just blindly execute them.

If you have (or purchase) TaskCentre for SalesLogix, it is possible to automate all the "Tell me about issues" checks, and also it's possible to automate the less scary ones of the "Fix" facilities.  If you need to know where to buy from, let me know.

An observation:  Most SalesLogix sites have customsations done, and most of these involve adding new tables and fields to the database.  Few sites have then proceeded to create additional integrity checks to check those new tables as well.

I hope that helps a little!

Regards, from Brisbane, Australia

Paul Roussell

SalesLogix Partner since July 1997.