preloader-matrix

Alfasith

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_TRACKING
CONTEXT_TRACKINGT’,
because it does not exist or you do not have permission.

Impact:

Results in synchronization 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,

Leave a Reply

Your email address will not be published.