column renamed via SQL Server causes problem in NAV

buchhot

Hi you NAV-Gurus!

We have some user defined tables (no standard NAV-tables) used by an external web tool as well as NAV.
One of our developers (of the support tool) renamed one column in a table via the SQL Server Enterprise Manager and not via NAV as told.
No I have the situation that the columns name is A and NAV thinks its B. I also annot change it in NAV, because he cannot find the old name.

How can I solve this?

Any ideas would be greatly appreciated ](*,)

Many thanks in advance

tinoruijs

Have you tried to rename the column in a table via the SQL Server Enterprise Manager back to the old name?

If that works, you then can adjust the column name via NAV.

buchhot

Hi tinoruijs!

Yes, also tried that, no chance.
We then created an new table and transfered all data.
Sounds crazy but I found no ther solution.

davmac1

I had a similar problem that I solved by renaming the constraints to match the naming convention used by NAV.
This involved looking at SQL's system tables and updating them.
All the metadata in SQL DDL has to match what NAV has else trouble.