SQL index issue in key

Business Central/NAV Technical Forum
1

Hi,

I am trying to add the new key in table “waste header”, but an error is throwing showing some index

1913 "“42S11”[Microsoft][ODBC SQL Server Driver][SQL Server] The
operation failed because an index or statistic with name ‘$9’ already exist on table

Document Type,Business Type, Contract Terminated, Busines with No, Expiration Date

Microsoft Dynamics NAV

The following SQL Server error(s) occurred while accessing the Waste Management Header table:

Regards

Pushpraj

2

Have you check whether the key already exist in Table ?

As well as try to update the statistics in SQL

3

I guess someone added a custom index to that table (via Management Studio) and named that one “$9” - which is an absolute “No Go”! Adding SQL site indexes could be quite benefitial, but in such a case you MUST stay away from NAV naming conventions!!!

So just rename this custom index - e.g. myidx01 - then you should be able to create the NAV key/index!