BUG: NOCHECK Does Not Allow Modifications to an Fkey Reference (158842)


The information in this article applies to:

  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbusage KB158842
©2003 Microsoft Corporation. All rights reserved.