MS Dynamics AX | Dynamics 365 | Azure | Office 365 | Power BI | Power Platform

select i . [name] as index_name ,     substring ( column_names , 1 , len ( column_names )- 1 ) as [columns] ,     case when i . [type] = 1 then 'Clustered index'         when i . [type] = 2 then 'Nonclustered unique index'         when i . [type] = 3 then 'XML index'         when i . [type] = 4 then 'Spatial index'         when i . [type] = 5 then 'Clustered columnstore index'         when i . [type] = 6 then 'Nonclustered columnstore index'         when i . [type] = 7 then 'Nonclustered hash index'         end as index_type ,     case when i . is_unique = 1 then 'Unique'         else 'Not unique' end as [unique] ,     schema_name ( t . schema_id ) + '.' + t . [name] as table_view ,      case when t . [type] = 'U' then 'Table'         when t . [type] = 'V' then 'View'         end as [obj

DB sync errors when change tracking is enabled for a table on sql server and you changed the field size. Example: In below, I changed the Num EDT size from 20 to 30, this EDT is used in InventDIM table which has change tracking enabled in SQL database. DB sync errored when doing a full data dictionary Synchronisation. Num EDT size changed from 30 to 20 Change tracking enabled on custtable and inventdim tables in SQL database DB sync error Fix:  Go to SSMS and find the table "InventDIM" in AX database Right click and select properties Select Change Tracking Change to False for both option "change tracking and Track columns updated" Click Okay Start DB sync and it should finish with out error Revert the change tracking property back to "True".