Browse By Tags

  • Wiki Page: 492-17877 - Webapp connection failure when using Latin1_General_Bin collation

    Summary: After installing a copy of Sage CRM onto an instance of Microsoft SQL Server using the Latin1_General_Bin collation, you may find that the CRM webapps cannot connect to the database. This is due to Latin1_General_Bin being a case-sensitive collation, and a setting in the db.properties being...
  • Wiki Page: 492-17885 - User Access Logging database performance issues

    Summary: Errors being logged by the User Access Logging (UAL) feature in Windows Server 2012 may result in poor database server performance. Symptoms: Users may report poor database performance when interacting with Sage CRM. This may take the form of timeouts, or actions taking longer than expected...
  • Wiki Page: 687-17980 - Linking to external table doesn't create entry in Custom_Edits

    Summary: If you create a connection to an external database, then a table connection based on the external database the Custom_Edits table will not auto populate with the fields from the external table. Symptoms: Custom_Edits table is not automatically updated with the fields from an external table when...
  • Wiki Page: 710-18095 - SQL Views script

    Summary: This will list all of the views on the database with a column highlighting if they are working correctly or not. Views that are populated with ‘Bad’ will need to be dropped or refreshed. Please also be aware that some views are dependent on other views. Once you have fixed the issue...
  • Wiki Page: 710-18102 - SQL script that can be used to search a database for text.

    Summary: SQL script that can be used to search a database for text. Resolution: DECLARE @search_string VARCHAR(100), @table_name SYSNAME, @table_id INT, @column_name SYSNAME, @sql_string VARCHAR(2000) SET @search_string = 'Test' DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects...
  • Wiki Page: 710-18186 - SQL DATABASE QUERY

    Question: • Does Sage CRM supported encrypting the database via MS SQL Server encryption? • Does Sage CRM support SQL Server replication at database level? Answer: 1: We don’t support columnar encryption, since a key needs to be used with each SQL statement. We have issues with forced...