SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'I_XXXXXRECID' in the database.

1. Temporarily change the ConfigurationKey on the table to SysDeletedObjects63.
2. Right-click the table, click Synchronize. It will delete the table from the SQL DB.
3. Try to run full DB sync again, make sure there are no errors.
4. Delete the table from the layer you are working in. It will restore the SYS layer version of the table with ConfigurationKey to the old attribute.
5. Right-click the table, click Synchronize. It will create the table in the SQL DB. If you start getting DB sync errors at that point it will mean something else is wrong in your DB e.g. another table has an index with the same name (I_XXXXRECID) or something like that.

This query for check where index was store.

select object_name(object_id) from sys.indexes WHERE name =  'I_100013RECID'

SELECT OBJECT_NAME(object_id) AS TableName, * FROM sys.indexes AS I ORDER BY TableName, i.name;