Adding a key in table throws an error

pushpraj1008

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

ara3n

it looks to me like somebody created an index directly. open sql sms and delete the index 9