Event ID - 437

Event Id437
DescriptionCould not resolve the referenced column name in table ID %d.
Event InformationCAUSE:
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.

Follow these steps:
1. Execute DBCC CHECKDB for the database where the tables reside to verify that there are no database consistency problems.
2. Drop the existing foreign key constraint and, if needed, recreate a new foreign key constraint that references a valid column.
3. Verify that the allow updates option is off. For instructions on how to set this option, see "allow updates Option" in Books Online.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 437

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.