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,
Generate script to recreate the DDL with data and without data
Hi,
To recreate the DDL please follow below procedure
If you would like to generate the script with data please select Advance in that Advanced Scripting Option please select the type of data to script : Schema and data
on Successful finish of this wizard will open a script window and we can save or share to other instance to regenerate the DDL
Regards