SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the index [table Name.Index] because it does not exist or you do not have permission.
Hi,
Error:
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot drop the index ‘WORKFLOWTRACKINGTABLE.IX_WORKFLOWTRACKINGTABLE_
WORKFLOWTRACKINGSTATUSTABLE_PARTITION_TRACKINGCONTEXT_TRACKINGT’,
because it does not exist or you do not have permission.
Impact:
Results in synhronization failure.
Resolution :
1. Table a backup of the DB.
2. Delete the particular index from SQL side and synchronize the respective table in application.
Regards,