Error Synchronize database Cannot execute a data definition language command on (). The SQL database has issued an error.

When production database has been copied to the test database or development database then we usually get below type of error during database synchronization after applying model store.

(C)\Classes\Info\add 0
(S)\Classes\xApplication\dbSynchronize 0
(S)\Classes\Application\dbSynchronize 30
(S)\Classes\SysSqlAdminClass\handleSelectedItems 34
(C)\Forms\SysSqlAdmin\Methods\runThroughTablesAndIndexes 42
(C)\Forms\SysSqlAdmin\Designs\DesignList\buttonSynchronize\Methods\Clicked 6
Info Synchronize database SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'I_111882RECID' in the database.
Info Synchronize database SQL statement: ALTER TABLE "DBO".TAXGSTREPORTCONFIGURATIONLINECODE_MY ADD CONSTRAINT I_111882RECID PRIMARY KEY CLUSTERED (RECID) WITH (DATA_COMPRESSION = ROW )
Error Synchronize database Cannot execute a data definition language command on  ().

The SQL database has issued an error.

You can try to solve the problem from below approach

1.  Just try to synchronize the individual table and check if there will be any database synchronization error or not
2. Check the SQL dictionary table and filter with the table id check if all the id's are proper or not.
3. There might be a problem that id of the index on this table already exists on the another table. you can query on the database that on which table this index id is present.
4. Check if there is any data in it or not if there is no data in it then you can try to delete it from SQL and same time try to sync it from AX. it will regenerate it.