Error - change SQL type from undefined til VARIANT

vptavpta Member Posts: 27
edited 2009-10-13 in SQL General

I have a problem changing the type in tabel 110,112 and 114. After a while I get an error message:

3728,”42000”,Microsoft ODBC SQL Server Driver`”Tabelname”$0 is not a constraint (se the attached file)
(the first sentence in norwegian only says : The following error occured when accessing table....

I have deleted all the KEYS exept primary (No.) and I still get this message.

The db i 5.0 klient 5.01 and MS-SQL2005
Trond A Anvik
Vision Partner AS


  • DenSterDenSter Member Posts: 8,304
    Sales Invoice Header$0 refers to the primary key of the table, which is implemented on SQL Server as a primary key constraint. It appears as though when you save the new SQL type, it wants to drop the constraint by name, and it can't find it. Did you modify any of the tabe design directly on SQL Server at any point in time?
  • vptavpta Member Posts: 27
    No, I have never modified this table directly, always with the Navision C/SIDE client.
    Trond A Anvik
    Vision Partner AS
  • kinekine Member Posts: 12,562
    1) Are you db_owner of the database?
    2) Look at SQL and check that this constraint exists. If not, try to create it with this name.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.