• How to identify reports or groups that reference specific views?

    We're experiencing periodic slowdowns in our recently-upgraded Sage CRM 7.2 system, and see a lot of these kinds of errors: You may need to recreate views manually. : SQL Error Well, we should clean those out anyway. When I try to edit some of our…
  • Incorrect Syntax near '*' (select cListOpportunity.count(*)

    Dear All I am looking for some help if possible as it would appear that our issue has both our support partner, and Sage stumped. We have the standard system view vListOpportunity in the DB, however, for some reason on a fairly regular basis, this…