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,

Share on email
Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Leave a Reply

Your email address will not be published.