Tag: SQL

You can use the SQL console or a SQL command to shrink a Infor CRM SQL database log file that has grown too large, but be sure to back up the database first.

As I mentioned in last week's post, using the Full recovery model in SQL in an Infor CRM database would prevent some data loss in the event of a database failure, but would require more careful management of the SQL logs. In today's post, I will expand on that. When using the Full recovery model in SQL, every transaction is...

In the SQL database for Infor CRM, you can set the recovery model to Simple or Full.

If you need to determine the objects that are related to another object in Creatio, there's a few ways to do this. For example, let's say you want to find all of the objects that have a relationship to the account object - meaning, find all the objects that have an account lookup. We'll take a look at two...

In order to prepare a SQL server to run Infor CRM, you must set up a SQL login for CRM to use, and must link it with the sysdba user in the CRM database.

Use the sa SQL account to move or restore CRM databases, but use sysdba to connect to them.

Creatio does have a lot of options for working with objects/data with an Entity object model, EntitySchemaQuery, Select/Update/Insert objects (I'll get around to writing articles on these topics as well). You can also execute a SQL statement directly when needed as well. Before we get into the code, it's worth mentioning, executing a SQL statement directly in the database won't...

It is possible to clear the user settings in the CRM LAN client (formerly SalesLogix) using a SQL query.

If you are running some email sync, and it having issues completing, one possible solution is to purge the GLOBALCHANGETRACKING table of all its old delete records.

Adding Columns in Infor CRM Querry Builder can be confusing, as columns are listed based on the organization of the database, rather than what is displayed in the Client.