Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
3rd Party Software
CRM Standalone Install
Windows 2008 (64)
Windows Server 2012
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...
23 Jul 2015
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...
10 Jul 2015
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...
18 Nov 2015
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...
20 Jul 2016
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...
20 Jul 2016
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...
21 Sep 2017
© The Sage Group plc 2019
All Rights Reserved