Logging database changes (form) [AX 2012]

Updated: November 18, 2010

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click System administration > Setup > Database > Database log setup. Click New.

Use this wizard to start logging changes to specified tables and fields.

Database logging, although it can be valuable from a business perspective, can be expensive as measured by resource use and management. For more information about recommended practices when logging, see Configure and manage database logging.

The following sections describe the pages in the wizard.

This page introduces you to the wizard. Click Next to move to the next page.

Select the tables or fields that you want to log changes to, then click Next.

By default, Administrator and System tables are excluded from the list.

Select the types of change to the table (insert, update, delete, or rename key) that you want to record in the log. Rename key changes occur when a table's foreign or primary key has been changed.


For individual fields, only updates can be logged.

The Finish page lists the table and field changes that will be logged. Click Finish to start logging.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).