When I am trying to create a new key in Item Ledger Entry Table, system returns the following error:
The following SQL Server error or errors occurred when accessing the Item Ledger Entry table:
1913,“42S11”,[Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name ‘$37’ already exists on table ‘Navision15012012.dbo.Trident15012012$Item Ledger Entry’.
Take a look at your keys for the table. You can do this by highlighting the table you want and click Design. Then, from the toolbar, click on View and then Keys. Duplicates keys are not allowed. Read your error message carefully. It will tell you where to look for the error
Before you create your new key on ILE table. Just check whether that key is already exits or not . If exits then use that key. if not then go to the SQL sever management studio and then go to the ILE tabe and delete that Index $37 then recreate that key from Nanvision.