The Statistics '_dta_dams_stat_2126801566_113_114_101_126' is dependent on column 'XXXXX'

Database synchronization is a crucial aspect of any application that relies on a database for storing and retrieving data. However, there can be times when the synchronization process encounters issues, causing data to be inconsistent or lost altogether. In this article, we'll explore a common cause of database synchronization issue and how to fixed it.

Error:

Sometimes during database synchronization we faced this kind of error:

Solution:

In order to fix this error, just run the below query in SQL server. After that run DB sync again. It'll run successfully. DECLARE @sql NVARCHAR(MAX) DECLARE statCursor CURSOR FOR SELECT 'DROP STATISTICS ' + QUOTENAME(SCHEMA_NAME(t.schema_id)) + '.' + QUOTENAME(t.name) + '.' + QUOTENAME(st.name) AS sql FROM sys.stats AS st INNER JOIN sys.tables AS t ON st.object_id = t.object_id WHERE st.user_created = 1 ORDER BY 1; OPEN statCursor; FETCH NEXT FROM statCursor INTO @sql WHILE @@FETCH_STATUS = 0 BEGIN PRINT @sql EXEC sp_executesql @sql FETCH NEXT FROM statCursor INTO @sql END CLOSE statCursor DEALLOCATE statCursor

Enjoy :)