SQL error on enabling a new key

Has anyone come across this error: We have Navision Attain 3.01B (SQL Server). I added a new key to the Item Ledger Entry table (32), with a sum index field. The table compiles OK on our test database. When importing to the live database, then trying to compile the table, I get the error: The following SQL Server error(s) occurred while accessing the Item Ledger Entry table: 2714,“42S01”,[Microsoft][ODBC SQL Server Driver][SQL Server] There is already an object named ‘CTP Carrera Live$32$6’ in the database. I have never seen this before, and as far as I can see, the keys are defined identically in the live and test versions of the table. Any ideas greatfully received. Andy

I have seen this error before at one of out client. Client is running on SQL. we renamed the table name on our local database, and we got this error, when we try to import the table into thier production. The problem is Navision table object is not properly synchronized with SQL Table object. Only way is do your Key modification directly on the live database. DO not import the table. Naveen Jain

Hi, Use the System Administrator i.e. SA login to import the file using a relevant license file. You should be able to go through. Cheers,