Category Archives: Database

Interactive Dashboard refuses to work? This could be related to SQL Server Configuration error

Everyone over here must be very much aware of Sage CRM installation process and its pre-requisites. But if you are facing Sage CRM installation for the first time then, it can be a little daunting. As successful CRM installation process itself determines or say confirms whether you will be facing tomcat related issues or not.… Read More »

Error exporting reports to excel in CRM part 4

As you know we have been writing blogs on issues being faced while extracting reports data in excel and issues related to Dashboards not working. You can go through the links added below for your reference. Related Stuff: Error exporting reports to excel in CRM part 3 Even in today’s blog, we will be discussing… Read More »

How Sage CRM changed Structure of Phone and Email in Sage CRM 7.2

Hi folks! You all must be familiar with the following entities in CRM ”Email”, “Email Link”, “Person” ,“Person Link” ,”phone” and “Phone Link“ table .These are the tables where person’s and company’s communicated related details are saved. But when you want to check one of these details in database for the related company or person… Read More »

Scheduling Backup activity through Sage CRM 2014 R2

For every Business environment, managing/securing data and Disaster management responsibilities goes hand in hand. Backing up data has always been the only recommended solution for recovering data which also proves very profitable. The only risk which is involved is doing this task manually as someone may forget. Scheduling Backup activities is something which has been… Read More »

Get Size of all Tables in CRM Database

For any database driven application, it is very important that the database must be optimized to the best so as to deliver higher performance. As the data volume in database increases, load on the system also increases which affects the performance on the system which in turn affects the client’s business. For business application like… Read More »

CRM database auto-backup on SQL express Editions

Database backup is very essential in business environment to keep disaster recovery options open. Maintaining every day database backup is routine practise for all software friendly industries. However doing this task manually is very tedious job and involves lot of risk if someone forgets to backup.  New Stuff: Sage 100 user mapping with Sage CRM… Read More »

Table Level Scripts Logging and Performance

In SageCRM, Table level script can be used for replicating SQL trigger like functionality.  Table level scripts help us handle the data update events properly and do corresponding actions within SageCRM. The beauty of it is we can use SageCRM API and write server side JavaScript like functionality to function similar to that of triggers.… Read More »

Sage CRM Database Maintenance

Database is the most important part of any application. Being business software, Sage CRM handles very delicate data and it is necessary to maintain this data properly in order to insure integrity and improved system performance. New Stuff: Confirm if your Sage CRM system has actually expired There are many ways to enhance the performance… Read More »