Use this form to configure the database settings that are used when you select in the SQL Administration form. You can select General, Print, and Index settings.

Tasks that use this form

Navigating the form

The following tables provide descriptions for the controls in this form.

Buttons

Button

Description

Accept the changes and exit the window.

Cancel changes and exit.

Fields

Field

Description

Select this option to report but not repair any problems detected.

Select this option to automatically synchronize the database so that changes take effect immediately.

Select this option to detect and remove working (temporary) tables. If working tables contain data, you will be asked whether you want to delete the table.

Select this option to have the function assume that if two fields that have different names exist in Microsoft Dynamics AX and in the database, it should be handled as a failed attempt to rename a field. The correction is only made if no other differences exist in the table.

Select this option to set the function to require user input in order to continue. The default is to run in batch mode.

Select this option to validate the attributes of the fields in a table that are automatically created and populated by Microsoft Dynamics AX.

Note Note

Selecting this option can significantly increase the time that is required to run the process and is not recommended.


Select this option to check whether fields have been expanded to arrays.

Note Note

Selecting this option can significantly increase the time that is required to run the process and is not recommended.


Select this option to generate a report that contains all problems found during the process.

Select this option to generate a report that contains only errors that the process cannot resolve.

Select this option to find and repair differences between the Microsoft Dynamics AX data dictionary and the indexes in the database.

Select this option to identify duplicate rows in a table. Use this function when you are adding an index to an existing table that may contain duplicate rows.

To use this option, and must also be selected.

Select this option to remove indexes that are not defined in the AOT from the selected tables.