I am doing an update to Navision 2009 SP1 SQL.
I have a navision 4 SP1 that works with SQL 2000.
When I open the database with Navision 2009 SQL to convert
the following message of error apears appears :
SQL Server Error to access table Object Metadata.
207,“42S22”,[Microsoft][ODBC SQL Server Driver][SQL Server] invalid column name “Object Id”.
207,“42S22”,[Microsoft][ODBC SQL Server Driver][SQL Server] invalid column name “Object Id”.
CREATE TRIGGER [$ndo$objecttracking]ON [dbo].[Metadatos objetos ]
FOR DELETE , INSERT , UPDATE AS
etc…
etc…
If I try the second method and restore a copy of the database
the error that appears:
SQL Server Error to access table Object Metadata.
207,“42S22”,[Microsoft][ODBC SQL Server Driver][SQL Server] invalid column name “Object Id”.
207,“42S22”,[Microsoft][ODBC SQL Server Driver][SQL Server] invalid column name “Object Id”.
SQL:
UPDATE “databaseName”.“dbo”.“Object Metadata” SET “Metadatos” = NULL WHERE ((“Tipo Objeto”=5))
The SQL is Microsoft SQL Server 2008.
Some weeks ago I did the update to test the database and I think that goes all OK.
I tested the navision 2009 database during some weeks and last week I decided to do the final update.
I think that I did the same but I don’t know the reason of the error.
Someone has an idea to solve my problem ?
Thank you.