DEVOPS - AX 2012 DB sync error during VSTS build run
When running database synchronisation as part of the build process in DEVOPS or through AX directly. If you have any indexes created directly in AX SQL database for performance purposes or other reason, DB sync drops them without issue. In some cases, DB sync fails to drop these indexes with below error. Rename the indexes with out any special characters in the first and last character of the name Re run the db sync Sync finishes and drops indexes. Finding the failed sql statement: On the log of the build step, if you scroll down, you can find the sql statement. Copy the statement to SSMS and execute to find the error.