Archive | February, 2012

An error occurs if you select more than 20 records for a CRM Report

Hi folks, we have noticed that there is an error when selecting more than 20 records fo a CRM report. This was true for our own and for CRM standard reports. The error message is the following: The SELECT permission was denied on the object ‘fn_GetGuidsFromString’,…
Read full story Comments { 1 }

MS CRM 2011: Antivirus exclusion list

Sure, you must use a antivirus software, but this can slow down your client communication, therefore a exclusion list must be set. For a better performance you can test this exclusion list: Web Addresses http://<CRMServerAddress>:<PortNumber>/…
Read full story Comments { 0 }

The custom 4.0 views are not non-selectable using the custom application

Hi, today I want to share a support issue with you. I have included a summary of the case below for you to keep in your records for future reference when migrating any further CRM 4.0 system to CRM2011. Summary symptom customer has created a custom application for CRM…
Read full story Comments { 0 }

Count more than 5000 Records in CRM views

Hi, within  MS CRM 2011 it is possible to count all list entries in views, but this is limited to 5000 records. If you have more than 5000 records in a view you will get 5000+ as the count result. Just a simple SQL statement against the CRM config database…
Read full story Comments { 0 }

Shrink TEMP DB

Hi folks, we had a curious issue. The TEMP DB database of the SQL Server 2008 has grown disproportionately and even after restarting the database and the SQL server itself don’t helps. A colleague found this little script:  ALTER DATABASE tempdb MODIFY…
Read full story Comments { 0 }