Knowledge Base

BUG: NOCHECK Does Not Allow Modifications to an Fkey Reference

Article ID: 158842

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q158842

BUG #: 14592 (Windows NT: 6.50)

SYMPTOMS

The NOCHECK option for the ALTER TABLE command does not allow a modification to a column or row that is referenced by a foreign key constraint.

WORKAROUND

To work around this problem, drop the foreign key constraint before making the modification.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbbug kbusage KB158842