one field does not exist in Sql server table or view?

nebular

When I backup the database, navision give me a error:
The Lot N?on quote field on the sales line buffer table does not exist in the SQL Server table or view.

then backup stop.
has anyone an idea?

awarn

Was this field deleted from SQL Server and not Navision?

GoMaD

I've got the same problem, but the field isn't deleted from Navision. The field in my db is named on SQL level "Volume M³" and on Navision Level it's named "Volume my".

I"ve tried changing the name in Navision to the SQL name, but that doesn't work (error as nebular mentioned).
I can change the SQL name so that it matches the navision one, but still the same error.

Anybody?

DenSter

Make sure that the collation of the original database is the same as the database that you are trying to restore into

ls

I've the same problem on NAV 2009 SP1. Do you have any suggestion, please?

ls

GoMaD

search for special characters in the column names