Could not resolve the referenced column name in table ID %d.

Details
Product: SQL Server
Event ID: 437
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Could not resolve the referenced column name in table ID %d.
   
Explanation
This error occurs when you try to modify data in a table with a foreign key that references a column that no longer exists in the referenced table. Merely renaming a column will not cause this error. Under normal circumstances, a column referenced by a foreign key cannot be dropped, so this error may indicate that unsupported direct system table updates have occurred.

If you first see the error only after a restart of the SQL Server instance this may indicate that prior foreign key references were using cached information about the column that was dropped. Therefore the column may have been removed any time since the last restart of the SQL Server instance.

   
User Action
Follow these steps:

  • Execute DBCC CHECKDB for the database where the tables reside to verify that there are no database consistency problems.
  • Drop the existing foreign key constraint and, if needed, recreate a new foreign key constraint that references a valid column.
  • Verify that the allow updates option is off. For instructions on how to set this option, see “allow updates Option” in Books Online.

Related:

Leave a Reply